how to retrieve images in vb.net.....................................this code is for saving images
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String = "INSERT INTO advertisement VALUES(@advertisement)"
con = New SqlConnection("data source=I3-001\SQL2008R2; initial catalog=SmsDb; user id=sa; password=bss123")
con.Open()
Dim query = "insert into advertisement(advertisement) values(@advertisement)"
cmd1 = New SqlCommand(query, con)
Dim ms As New MemoryStream()
PictureBox1.BackgroundImage.Save(ms, PictureBox1.BackgroundImage.RawFormat)
Dim data As Byte() = ms.GetBuffer()
Dim p As New SqlParameter("@advertisement", SqlDbType.Image)
p.Value = data
cmd1.Parameters.Add(p)
cmd1.ExecuteNonQuery()
con.Close()
End Sub