Question insert pictures into sql database in visual basic

[clzanas]

Hi guys,

I am trying to retrieve the image that i linked to the database in visual basic.

i have linked to the file directory like C:\filename.jpeg

I put this directory in the database but now i dont know how to retrieve the picture.

i have coded the code like this

ds.Tables("ABCcondo").Rows(i).Item(6) = PictureBox2.BindingContext

but i cannot get the picture out although there is no errors in vb.

Hope someone can help me thnks!!

regards,

Charles

 

[cjard]

If you have stored the path to the image in the db, try the Image.FromFile method

 

[clzanas]

hi cjard,

thnks for the reply. May i know how to use that property, as i'm new to VB?

My guess would be

Image.FromFile = ds.Tables("ABCcondo").Rows(i).Item(5)

the same method that is used to extract the info from sql database?

 

[MattP]

Here's the online help for Image.FromFile.

Image.FromFile Method (System.Drawing)

 

[cjard]

My guess would be

In programming, guessing gets you less far than googling