hi all

i have a problem £¬how to display an image type data from SQLserver

databasse in winform using vb.net .who can tell me a method ,thanks.

Hi

Although this is possible, it is not recommended.
In your case, would storing the file location and loading it from the file system not be an option?

If not, the data type used in sql, can be Image or Binary.
make sure your column is of this type and create a stored procedure to add entries into the table.
You would have to store the image as a byte array.
ie. (psuedo code below - to give you an idea)

stream = new System.IO.FileStream (yourfile)
byte[] buffer = stream.Read()
'insert into database using stored procedure
sqlcommand = new SqlCommand()
sqlcommand.Parameters.Add("@YourParam", buffer)
sqlcommand.ExecuteNonQuery()

I hope this helps



Jonathan Crossland
http://www.jonathancrossland.com

To get the image out again.

'Get the byte array back again via a query to database
'create sqlcommand and connection objects
'get the array
byte[] buffer = (byte[])sqlcommand.ExecuteScalar()
'create a stream
memStream = new System.IO.MemoryStream(buffer, true)
myBitmap = new Bitmap(memStream);






Jonathan Crossland
http://www.jonathancrossland.com