[RESOLVED] Storing a picture in SQL 2000

[1druid1]

Hi All

I have the following code that I use to convert a picture into bytes.

 Dim strImageFilePath As String = _ 
LblPicture.Text 
Dim fsImageFile As New FileStream(strImageFilePath, _ 
FileMode.Open, FileAccess.Read) 
Dim bytImageData(fsImageFile.Length() - 1) As Byte 
fsImageFile.Read(bytImageData, 0, bytImageData.Length) 
fsImageFile.Close()

This then gets used to store into an SLQL 2000 VarBinary field.

I thought the above would work but its only letting me save pictures that are under 8k in size, but I need to be able to save much bigger files than that.

Any help is appreciated.

Cheers

Dougie

[HanneSThEGreaT]

How much bigger ¿

[1druid1]

Hi

Thanks for the reply, the size of the picture depends on the user taking it, although I am going to teach them how to reduce picture sizes, so hopefully 1mb maximum, but the possibility of more would be good. I had written the program to use a file store instead and just link the picture via filename, but it didnt work very well as the users copied, moved deleted pictures, and refernces ended up lost. So I want to store the pictures in the database to get around this problem.

Cheers

Dougie

[Cimperiali]

did you already see this?
http://www.vbdotnetheaven.com/upload...sqlserver.aspx
the type of field used to store content in Sql Server 2000 is "Image"

[1druid1]

Thanks Cimperiali

All I needed to do was change from a VarBinary to an Image field, I didnt even noticce the image field.

Cheers

Dougie

[Cimperiali]

you're welcome

[HanneSThEGreaT]

Thought the problem may be with the size of the picture, sorry Dougie.

Just shows, a person always think a problem is "Very complicated", but mostly isn't