Blob file from mysql database

[Buntaflex]

Hello there,

i have some database with blob files stored in:

here is my radzen datagrid and its columns:

<RadzenDataGrid @ref="TabPamPinArrGrid" 
                    Data="@TabPamPinArr" 
                    Count="@countLib" 
                    TItem="TabPamPinArrangement" 
                    AllowFiltering="true" 
                    FilterMode="FilterMode.Advanced" 
                    FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive"
                    AllowColumnPicking="true" 
                    AllowGrouping="true" 
                    AllowColumnResize="true" 
                    AllowSorting="true"
                    AllowPaging="true" 
                    PageSize="30" 
                    ShowPagingSummary="true"
                    Density="Density.Compact" 
                    PagerHorizontalAlign="HorizontalAlign.Left"
                    RowRender="@PinArrRowRender"
                    ExpandMode="DataGridExpandMode.Single">
                         <Columns>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="Id"            Title="Id"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="sSpecOwner"    Title="Spec Owner"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="sPartSerie"    Title="Part Serie"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="sArrSerie"     Title="Arrangement Serie"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="sArrName"      Title="Arrangement Name"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement" Property="sCtCode"       Title="Contact Code"/>
                            <RadzenDataGridColumn TItem="TabPamPinArrangement"                          Title="Image"/>
                                <Template Context="TabPamPinArrangement">
                                    <RadzenImage Path=""/>
                                </Template>
                        </Columns>

and here is how i set my datagrid content:

protected override async Task OnInitializedAsync()
    {
        await base.OnInitializedAsync();
        DataAccess db = new DataAccess();
        MemoryStream mStream = new MemoryStream();
        TabPamPinArr = db.GetConnLib().AsEnumerable();
        foreach (TabPamPinArrangement connector in TabPamPinArr)
        {
            mStream.Write(connector.bRawImage, 0, Convert.ToInt32(connector.bRawImage.Length));
            connector.Image= new System.Drawing.Bitmap(mStream,false);
        }
        countLib=TabPamPinArr.Count();
    }

i would like some help to set up the radzen image property... i don't get correctly how to use the path property with a class filled by some mysql data

thx and kind regards

[enchev]

There are plenty of threads discussing this topic:
https://forum.radzen.com/search?q=blob%20image

[Buntaflex]

So happy to use radzen with this kind of answer...

could you at least explain where we can find the location of @order.Employee?.Photo in the datagrid hierarchy example ?

it's not in a list modeled by some class
it's not a path on the computer
it's not from an email with gravatar
and it's not from some url

<Template Context="order">
                    <RadzenImage Path="@order.Employee?.Photo" style="width: 32px; height: 32px; border-radius: 16px; margin-right: 6px;" />
                    @order.Employee?.FirstName @order.Employee?.LastName
                </Template>

i swear i try my best to use your tools and your documentation on my own to manage something but some documentation is still missing...
plus, after reading all the treads you linked i didn't find any part of an answer on what i have to do to solve my issue.

regards

[enchev]

@Buntaflex

So happy to use radzen with this kind of answer...

Well, looks like you didn't bother to read any of the threads I've linked. Short answer is: RadzenImage can display images from url only including base64 encoded strings - you need to convert your binary data to base64 encoded string as shown again in the threads I've linked. I've updated also our Image component demo to show exactly the same: