i want to retrieve the image from the sqltable the image is tored in a binary format

Question

hai i want to retrieve image from sql table which is stored in the format of binary data with image. I just want to display the image in my web page thats all.. im not using with data grid also... Thanks

Suthish Nair · Answer

change and try if ( rdr.Read()) { byte[] bytePhoto = File.ReadAllBytes(rdr[photo]); Response.OutputStream.Write(bytePhoto 0 bytePhoto.Length); //Response.ContentType = image/jpg; }

Raju Katare · Answer

Hi Krithika First you asked that how to display image which is stored in a sql table in the format of Binary Data then you can get solution to this problem using Handler.ashx Template of ASP.Net (which is there in above article.)

krithika muthukrishnan · Answer

hai i didn't get the solutioni use this codeit displays the file path of the imageusing that file path how to display in a c# file SqlConnection con = new SqlConnection ( @data source=System-7\sqlExpress;initial catalog=Forum; User ID=sa;Password=as; ); con.Open(); int i = 1; string query = select photo from members where userid=' +i+ ' ; SqlCommand cmd = new SqlCommand (query con); SqlDataReader rdr = null ; rdr=cmd.ExecuteReader(); if ( rdr.Read()) //yup we found our image { Response.BinaryWrite(( byte [])rdr[ photo ]); } con.Close();

Raju Katare · Answer

Did you get the solution?

Raju Katare · Answer

Hi Krithika Have a look at Handler class of GridView nested inside another GridView in ASP.NET article to retrieve the image from database table column of type Varbinary(max). .