How to save image

[DapDap]

I have manage to open a image into a picture box. But I
have problem in Saving it into database SQL Server. How
to save the image ??

 

[Cor Ligthert]

DabDap

Did you see this sample of me that is in this message before
http://groups.google.com/groups?selm=#[email protected]

It uses a xml dataset however the rest is the same.

I hope this helps?

Cor

 

[Mike McIntyre]

To read images from and write images to Sql Server see this MSDN article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;326502

--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

 

[Cor Ligthert]

Mike,

There is a newer one on MSDN
http://support.microsoft.com/default.aspx?scid=kb;EN-US;308042

However when I see all those setting to nothing as well in that, I get the
idea that it is written and than it was ready.

Cor

 

[Guest]

I have gone threw this tutorial. But when I retrieve the image from the DB.
The image is only 1B, and I cannot open it. The filename is correct.

Whats wrong here?

 

[Ken Tucker [MVP]]

Hi,

You have to store the image in binary format. Storeimage converts
image to binary format. ConvertToBitmap converts it back. Note the offset
for the northwind database is 78 my storeimage function has a offset of 0.

Private Function StoreImage(ByVal bm As Bitmap) As Object

Dim ms As New MemoryStream

Try

bm.Save(ms, Imaging.ImageFormat.Jpeg)

Return ms.GetBuffer

Catch

Return Convert.DBNull

End Try

End Function

Private Function ConvertToBitmap(ByVal data() As Byte, ByVal offset As
Integer) As Bitmap

Dim ms As New System.IO.MemoryStream

Dim bm As Bitmap

ms = New MemoryStream

ms.Write(data, offset, data.Length - offset)

bm = New Bitmap(ms)

Return bm

End Function

Ken

----------------------

I have gone threw this tutorial. But when I retrieve the image from the DB.
The image is only 1B, and I cannot open it. The filename is correct.

Whats wrong here?

 

[Guest]

I'm using SQL Server 8 - and does exactly as the article -
http://support.microsoft.com/default.aspx?scid=kb;EN-US;308042