How can I read the Binary data from DataBase

  • Thread starter Thread starter Husam
  • Start date Start date
H

Husam

Hi EveryBody:

I have probelm that I hung with for three weeks, My problem is I want to
read Binary data from database. I will told you what I did :

first I declear an array byte and I cast the value in the database to byte
after that I use memory stream then I read the value by using method
FromMemoryStream that In Image class to finally but my pic In PictuerBox.

My code is lookslike the following:

Dim pic() as Byte=Ctype(myreader.getvalue(1),Byte())

myreader is the data reder that I used to read my data from database.

dim ms as new memorystream(pic)

with PictureBox1
..Image=Image.FromMemoryStrem(ms)
End with
But the probelm is I getthe length of pic() 0 thatmena there is no value.

I tried Alot of method and see alot Of Articals In reading blob or Binary
data from database but non were useful

So is thereany body can help me in this issue or direct me to any where to
do so?
 
Hi,
Try this I am using this for reading the BLOB data it might work for you

Dim BTImage() As Byte

BTImage = lsDs.Tables(0).Rows.Item(0).Item("DOC_CONTENT")
lsDS is dataset, change DOC_CONTENT to your column name

then assign the BTImage to the picturebox

in my case I having document I am converting the binary to ASCII I am able
to display the large text with image

picturebox1.image = System.Text.Encoding.ASCII.GetString(BTImage, 0,
BTImage.Length)

you can try this also

Thanks
Raghu
 
Back
Top