Hey Guys,
I have saved my images into database like follow.
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim cmd As New SqlCommand("INSERT INTO Info VALUES(@name,@photo)", con)
cmd.Parameters.AddWithValue("@name", TextBox1.Text)
Dim ms As New MemoryStream()
PictureBox1.BackgroundImage.Save(ms, PictureBox1.BackgroundImage.RawFormat)
Dim data As Byte() = ms.GetBuffer()
Dim p As New SqlParameter("@photo", SqlDbType.Image)
p.Value = data
cmd.Parameters.Add(p)
cmd.ExecuteNonQuery()
MessageBox.Show("Name & Image has been saved", "Save", MessageBoxButtons.OK)
End Sub
Now, On the button click event of "btnSearch_Download", I want to search image by name and
download the image saved into database to computer hard drive by giving option to user with
"save file" Dialogue box, where user can choose where he want to save a image file.
Basic code i have used is
Private Sub btnSearch_Download_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch_Download.Click
cmd = New SqlCommand("select photo from Info where name='" & TextBox2.Text & "'", con)
Dim imageData As Byte() = DirectCast(cmd.ExecuteScalar(), Byte())
End If
End Sub