How to view a blob Image field into Imagefield in wijmo:C1GridView

How to view a blob Image field into Imagefield in wijmo:C1GridView

Posted by: roberto_tomasi on 9 November 2020, 11:11 pm EST

• 

  roberto_tomasi

  • Post Options:
  • Link
    Copy

  Posted 9 November 2020, 11:11 pm EST

  Hi i must to view a blob Image field from Sql Server into Imagefield in wijmo:C1GridView
  any idea?
• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Replied 10 November 2020, 6:19 pm EST

  Hi Roberto,
  We are sorry for the inconvenience, we are unable to find a way to show the Image from Blob. Hence, we have forwarded this to the concerned team for further investigation with the internal tracking id C1WEB-27503.
  
  Regards,
  Manish Gupta

• Marked as Answer

  

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Replied 3 January 2021, 11:15 pm EST

  Hi Roberto,
  Please try to use the following code:
  Server-side: Create a method that converts to base 64 string from a byte array stored in DB
  
  

  // 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);
  }

  
  Client-side: Call method in server-side to get the image source because image source must be a string
  
  

  <wijmo:C1TemplateField HeaderText="Image"> 
      <ItemStyle HorizontalAlign="Center" /> 
      <ItemTemplate> 
          <img src='<%# GetImageFromBlob((byte[])Eval("Image")) %>' alt=<%# Eval("Image") %> /> 
      </ItemTemplate> 
  </wijmo:C1TemplateField>

  
  
  Hope it helps!
  
  Regards,
  Manish Gupta
  
• 

  roberto_tomasi

  • Post Options:
  • Link
    Copy

  Replied 4 January 2021, 4:48 am EST

  Hi Manish
  Thank for your reply
  but i already solved
  in this way
  

  
  
  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>
  

  
  
  and in vb.net
  

  
   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
  

  
  
  
  at the next time
  bye