Saturday, November 15, 2008

Retriving Image from Sql Server in .NET

Retriving Image from Sql Server in .NET

Dim img1 As Byte()

Dim cmd As New OleDbCommand("select image from companyLogo", Conn)
Dim dr As OleDbDataReader

dr = cmd.ExecuteReader()
img1 = Nothing

While dr.Read

img1 = dr(0)

End While

Dim stream1 As New MemoryStream(img1)

Dim newImage As Image
newImage = Image.FromStream(stream1)
PictureBox1.Image = newImage
stream1.Close()


Click here for coverting VB .NET to C#.NET and viseversa

No comments: