HighTechTalks DotNet Forums  

How can I read the Binary data from DataBase

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet


Discuss How can I read the Binary data from DataBase in the Dotnet Framework (ADO.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Husam
 
Posts: n/a

Default How can I read the Binary data from DataBase - 12-24-2007 , 01:39 PM






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?

Reply With Quote
  #2  
Old   
Raghu
 
Posts: n/a

Default RE: How can I read the Binary data from DataBase - 12-26-2007 , 03:22 PM






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


"Husam" wrote:

Quote:
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?

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.