How to retrieve images from sql server?

[Luis Esteban Valencia]

How to retrieve images from sql server?

 

[BluDog]

How to retrieve images from sql server?

Luis

Convert the image to text to save it in the database:

<code>
Public Overloads Shared Function ToString(ByVal image As
System.Drawing.Image) As String
Dim ms As New IO.MemoryStream
image.Save(ms, System.Drawing.Imaging.ImageFormat.Png)
Return System.Convert.ToBase64String(ms.GetBuffer)
End Function

Public Shared Function FromString(ByVal imageString As String) As
System.Drawing.Image
Dim imageBytes() As Byte =
System.Convert.FromBase64String(imageString)
Dim ms As New IO.MemoryStream(imageBytes)
FromString = System.Drawing.Image.FromStream(ms)
ms.Close()
End Function
</code>

Hope this helps

Blu