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

change and try,

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

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.)

hai,
i didn't get the solution,i use this code,it displays the file path of the image,using 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();

Did you get the solution?

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). .