How to bind Image with varbinary at code behind RSS

• • Reply
  

  puicy

  Member

  8 Points

  6 Posts

  How to bind Image with varbinary at code behind

  Feb 10, 2012 02:36 AM|LINK

  Hi,

  I am doing a project developed in VS2008. I have image stored in mssql with datatype varbinary. Can give me example how to create image from varbinary to be display in radiobuttonlist?

  I might add image in radiobuttonlist's list items by

  //items.Attributes.CssStyle.Add("background-image", "url(" + BinaryToImage(mbinary) + ")");

  or append string.format to create html img in each list item with binaryToImage,code but failed to display it.Below is the code:

   public static string BinaryToImage(System.Data.Linq.Binary binaryData)
          {
              if (binaryData == null) return null;
  
              byte[] buffer = binaryData.ToArray();
              MemoryStream memStream = new MemoryStream();
              memStream.Write(buffer, 0, buffer.Length);
              System.Drawing.Image img = System.Drawing.Image.FromStream(memStream);
  
              return img.ToString();
          }
  

  Please advise.Thanks

  Regards

  PuiCY

• • Reply
  

  amit.jain

  Star

  11225 Points

  1815 Posts

  Re: How to bind Image with varbinary at code behind

  Feb 10, 2012 04:56 AM|LINK

  Please refer Display images in gridview from sql server database

  Don't say thanks rather mark my reply as "Answer" if it helps you
  amiT jaiN
  
  ASP.NET C# VB Articles And Code Examples
  • Edited by amit.jain on Jul 16, 2012 07:10 AM
• • Reply
  

  puicy

  Member

  8 Points

  6 Posts

  Re: How to bind Image with varbinary at code behind

  Feb 13, 2012 03:29 PM|LINK

  amit.jain

  Please refer Display images in gridview from sql server database

  Hi, I tried the example given above but still no luck on it. I would like to bind it in a radiobuttonlist control at code behind like this:

  foreach (ListItem items in rblLookupList.Items)
                  {
                      LookupDS dsLU = new LookupDS();
                      LookupDS.DTRow setRow = dsLU.DT.NewDTRow();
                      ds.DT.Clear();
                      setRow.LookupCategoryID = Convert.ToInt32('11');
                      setRow.LookupInternalID = Convert.ToInt32(items.Value);
                      dsLU.DT.Rows.Add(setRow);
                      ds = obj1.GetLookup(dsLU);
  
                      System.Data.Linq.Binary mbinary = new Binary((byte[])ds.DT.Rows[0]["LookupImage"]);
  
                      items.Text = "<asp:image width=\"30\" height=\"30\" runat=\"server\" id=\"imgIcon\" imageurl='<%# \"ImgHandler.ashx?ID=1\" %>' />&nbsp;" + ds.DT.Rows[0]["description"].ToString();
                                          
                                      }

  Please advise.

  Thanks

  • Edited by puicy on Feb 13, 2012 03:32 PM
• • Reply
  

  puicy

  Member

  8 Points

  6 Posts

  Re: How to bind Image with varbinary at code behind

  Feb 14, 2012 08:40 AM|LINK

  Hi,

  I had my solution already. I use 

  string src = "data:image/jpeg;base64," + Convert.ToBase64String((byte[])ds.DT.Rows[0]["ImgBinary"]);
  
  items.Text = string.Format("<img src=\"{0}\" runat=\"server\" />", src) + ds.DT.Rows[0]["Description"].ToString();

  Then, bind each item in foreach listitem of radiobuttonlist. This can work.

  • Marked as answer by puicy on Feb 14, 2012 08:40 AM