multiple image retrive from database

Question

Hi How to retrive multiple image from database in Asp.net on Image control. Database column have sstudent id(int) name(varchar)photo(varBinarymax)sig(varbinarymax) & doc(varbinarymax) in Sql Server I have inserted all details in Database successfully. But unable to retrive these on Web Page Kindly assist.

Umesh Kumar · Answer

Else you can use the below code Create a regular HTML img element like so: img runat = server id = image /> And in code behind do this: image . src = data:image/png;base64 + Convert . ToBase64String ( imageBytes ); Where imageBytes is a byte[] You are done. The image will be displayed.

Umesh Kumar · Answer

Hi Basically you can use this function to convert your byte data from your Db and pass it back to the image propertty of asp.net image control. public static System . Drawing . Image ByteArrayToImage ( byte [] bArray ) { if ( bArray == null ) return null ; System . Drawing . Image newImage ; try { using ( MemoryStream ms = new MemoryStream ( bArray  0  bArray . Length )) { ms . Write ( bArray  0  bArray . Length ); newImage = System . Drawing . Image . FromStream ( ms  true ); } } catch ( Exception ex ) { newImage = null ; //Log an error here } return newImage ; }