How to direct retrieve binary value from sql server using csharp?

Hi,

if (dt.Rows[0]["Photo"].ToString() != "")
                {
                    MemoryStream m = new MemoryStream(dt.Rows[0]["Photo"].ToString(), true);
                    picPhoto.Image = Image.FromStream(m);
                    m.Close();
                }

0

Sam Hobbs15y ago

There are also articles in this web site that can help you. You probably received an email after you created this thread with suggestions for articles to look at. Also look at the right side of this window for suggestions. You should also look at what other articles are available.

0

Satyapriya Nayak15y ago

Hi Black,

Please refer the below link

http://www.codeproject.com/KB/database/SqlFileStream.aspx

Thanks

0