Posted 9 November 2020, 11:11 pm EST
Hi i must to view a blob Image field from Sql Server into Imagefield in wijmo:C1GridViewany idea?
Forums Home / ComponentOne / ASP.NET Web Forms Edition Topics
Posted by: roberto_tomasi on 9 November 2020, 11:11 pm EST
Posted 9 November 2020, 11:11 pm EST
Hi i must to view a blob Image field from Sql Server into Imagefield in wijmo:C1GridViewReplied 10 November 2020, 6:19 pm EST
Hi Roberto,Replied 3 January 2021, 11:15 pm EST
Hi Roberto,// Convert by to string base 64
protected string GetImageFromBlob(byte[] data)
{
string base64String = Convert.ToBase64String(data);
return String.Format("data:image/jpg;base64,{0}", base64String);
}
<wijmo:C1TemplateField HeaderText="Image">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<img src='<%# GetImageFromBlob((byte[])Eval("Image")) %>' alt=<%# Eval("Image") %> />
</ItemTemplate>
</wijmo:C1TemplateField>
Replied 4 January 2021, 4:48 am EST
Hi Manish
on grid row i added
OnRowDataBound="grdConsegna_RowDataBound"
in the columns
<wijmo:C1BoundField DataField="Immagine" HeaderText="Immagine"
Visible="false"> </wijmo:C1BoundField>
<wijmo:C1TemplateField >
<ItemTemplate>
<asp:Image ID="myIMG" runat="server" ImageUrl="" Width="240px"
Height="180px" />
</ItemTemplate>
</wijmo:C1TemplateField>
Protected Sub grdConsegna_RowDataBound(sender As Object, e As
C1.Web.Wijmo.Controls.C1GridView.C1GridViewRowEventArgs)
' cambio l'image url al controllo image del template da me definito
If e.Row.RowType = DataControlRowType.DataRow Then
DirectCast(e.Row.Cells(5).FindControl("myIMG"), Image).ImageUrl =
"getImage.aspx?ID=" & e.Row.Cells(0).Text
End If
End Sub