Click here to Skip to main content
12,357,905 members (74,800 online)
Click here to Skip to main content
Add your own
alternative version

Stats

10.6K views
3 bookmarked
Posted

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

, 27 Sep 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
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)

Share

About the Author

Willem Hijlkema
Netherlands Netherlands
No Biography provided

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160621.1 | Last Updated 27 Sep 2010
Article Copyright 2010 by Willem Hijlkema
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid