How to retrieve image from database in vb.net 2010

See more:

VB

database

File-Upload

, +

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())
        'Tell me What to do here?
        End If
    End Sub