sql server programming: hi,

can we store the images in the database without using streams in
vb.net?

is there any way that i store the image without using stream. i
want to store different image formats tiff, bmp, jpg etc many other
types.

If your images are reasonable in size, you can use regular INSERTs: The
SqlClient example below assumes the image variable is a byte array
containing your image.

Dim command As New SqlCommand("INSERT INTO MyTable VALUES(@MyImage)",
connection)
Dim imageParameter As New SqlParameter("@MyImage", SqlDbType.Binary)
command.Parameters.Add(imageParameter)
sqlParameter.Value = myImage
command.ExecuteNonQuery()

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]