Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / Languages / VB10

Get an SQL Server blob field and show it in an PictureBox using VB.Net

0.00/5 (No votes)
27 Sep 2010CPOL 16.1K  
SQL Blob field into picture box

I assume that the data has been read into a dataset!


To read an sql blob field into a picture box, just do this:

'create a PictureBox or use the one on your form!
Dim pic As New PictureBox
'rs is the record set.
'.ImageContent is the field name containing the blob field.
'here is the catch, assign the blob field directly into an array of Byte
Dim img As Byte() = rs.ImageContent.ToArray
'write the array content into memory 
Dim ms As New MemoryStream()
ms.Write(img, 0, rs.ImageContent.Length)
With pic
   'assign some other properties here
   '
   'read the converted blob image into the picture box
   'use overload option one!
   .Image = Image.FromStream(ms)
End With

That's all!


I hope it's use full

Willem Hijlkema

the Netherlands

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)