//in Handler.ashx
public void ProcessRequest(HttpContext context)
    {
        string Name = context.Request.QueryString.Get("ProfileName");
        SqlConnection con = clsConnection.GetConnection();
        SqlCommand cmd = new SqlCommand("GetDatah");
        SqlDataReader dr = null;

byte[] imgContent=(byte[])command.ExecuteScalar();
context.Response.ContentType = "image/jpeg"; 
context.Response.OutputStream.Write(imgContent,0,imgContent.Length);

<asp:TemplateField>
                            <ItemTemplate>
                                <img src="~/ShowImage.ashx?FacultyID=<%# Eval(FacultyID) %>" runat="server" width="100"

protected void cmdView_Click(object sender, EventArgs e) 
    {     
//ReadWriteData is a class    
        ReadWriteData rwd = new ReadWriteData(); 
        string sb = rwd.ReadFile(@"C:\Documents and Settings\pa_mukeshk\My Documents\Visual Studio 2008\Execute 1.0.docx");

select t1.PartNumber,t1.BeginningDate,t1.EndingDate,sum(t.sales) Sales
	   from test1 t1 inner join test t 
	   on t1.PartNumber=t.PartNo
	   group by t1.PartNumber,t1.BeginningDate,t1.EndingDate

 protected void cmdActivatePofile_Click(object sender, EventArgs e)
        {
            SqlConnection con = Connection.GetConnection();
            HttpPostedFile uploadedImage=null;

protected void cmdView_Click(object sender, EventArgs e)
    {    
//ReadWriteData is a class   
        ReadWriteData rwd = new ReadWriteData();
        string sb = rwd.ReadFile(@"C:\Documents and Settings\pa_mukeshk\My Documents\Visual Studio 2008\Execute 1.0.docx");

select partno,sum(sales) sale from test where date >'2003-01-01' and date<'2006-01-01' group by partno

string SQL = "SELECT FileName,FileSize,ContentType,FileData FROM FileTable WHERE FileID = '" + FileID + "'";
        SqlConnection con = Connection.GetConnection();
        SqlCommand cmd = new SqlCommand();
        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(SQL, con);
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;