On Fri, 22 Oct 2004 08:13:10 -0500, "Luis Esteban Valencia"
<lu*******@haceb.com> wrote:
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