image from SQL

[Hrvoje Voda]

Does anyone knows how to get an image from sql database?

I managed to save an image(binary) into table, but I don't know how to
"transformed" it back to my aplication into grid.

Hrcko

 

[Glen Wilkin via DotNetMonster.com]

System.Data.SqlClient.SqlDataReader ldrReader;
ldrReader = mobjData.OpenDataReader("spGetImage",
"@n_ImageID",lintImageID);
ldrReader.Read();
byte[] lbteBlobData = new byte[0];
lbteBlobData = (byte[])ldrReader[0];