what is control that i should use to save image into my database
arjunsasidharan 297
what is control that i should use to save image into my database
I have attached a small demo project for reading and writing a image in a database. It was developed in VS 2003. Have a look at it and modify it according to your own needs.
More on thread
I want information on how to save images into the database and retrive the images into their various picture boxes using visual basic code in windows form.
can you assist me ?
I want to use vb.net to write a code that will save data into an sql server database and retrive it to a picturebox.
thanks
hi
i think u can't save apicture as apictur in database but u can save the link in database and u can call the picture by acommand or any call sentance
ex
if u save apicture in c:\test\p1.jpg
and
u save this path in database
u can
create acommand to Retriev the path
and change the url of image to the path
like
image.url="path"
i hope help u
Really thanks very much for the sample program.i really happy with the program i just learn the SQL server. like these program is very very useful to me.
Member 857553
'Save an Image to a memory stream so you can get the bytes
Dim sampleImage As Bitmap = New Bitmap(100, 100)
Dim mStream As New System.IO.MemoryStream
Dim ImageBytes As Byte()
sampleImage.Save(mStream, Imaging.ImageFormat.Png)
ImageBytes = mStream.ToArray
'Sample Insert image command
'Save the bytes from the image into a image or varbinary column
Dim com As New SqlClient.SqlCommand("Insert Into MyTable" & vbCrLf & _
"(MyImageColumn)" & vbCrLf & _
"Values(@MyImage)")
'an image column or varbinary column
com.Parameters.Add("@MyImage", SqlDbType.Image)
com.Parameters("@MyImage").Value = ImageBytes
'Sample Read Image Command
'Read the bytes from the table and create a new memory stream from them
com.CommandText = "Select MyImage From MyTable"
Dim rdr As System.Data.SqlClient.SqlDataReader
rdr = com.ExecuteReader
If rdr.Read Then
Dim newMstream As New System.IO.MemoryStream(CType(rdr.Item("MyImage"), Byte()))
'Create a new image from the bytes from the memory
Dim ImageFromDB As New Bitmap(newMstream)
End If
__avd 1,826
Friends! Do not resurrect old threads. This thread is quite old (3 years).
Thread closed.
Table:
CREATE TABLE [dbo].[imgtable](
[id] [int] NULL,
[img] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Code :
Dim cmd As New SqlCommand("insert into imgtable (id,img) values ( @id,@img)", cnn)
cmd.Parameters.AddWithValue("@id", id)
cmd.Parameters.AddWithValue("@img", content)
cmd.ExecuteNonQuery()
source: Store image in database - vb.net
winston