dotnet clr: See the code below :

I have not tested , it got it from somewhere on net , so , can't promise

Dim myConnection As New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim myCommand As New SqlCommand("Select * from ImgTable where imageid="
& imgId, myConnection)
Dim fs As FileStream
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("imgtype")
Response.BinaryWrite(myDataReader.Item("imageid"))
Loop
above code will display the image on the same page.
------------------------------------------------------------------------
if you want to write that file locally
Dim fs As FileStream
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Dim buffer() As Byte
buffer = myDataReader.Item("imageid")
If Not File.Exists("c:\temp\testing.bmp") Then
fs = New FileStream("c:\temp\testing.bmp", FileMode.Create)
fs.Write(buffer, 0, buffer.Length)
fs.Close()
End If



[quoted text, click to view]