Retrieve image from database c#

See more:

C#

ASP.NET

SQL

hi every one. i am working on c# program that retrieve image from database. i used http general handler to accomplish this operation. when i run my application and put check points everything is okay and work correctly and no error but image does not display on webpage. i am working on windows server 2008 , vs2008 .

the application work as following:
i had textbox1 and button. the user inter id of sql table row and click button1 to display image in image1 control.


---------------the Default.aspx code :

var ids = (from g in dh.SessionQuestions
where g.idMain == Convert.ToInt32(TextBox1.Text)
select g).ToList().FirstOrDefault();
Label1.Text = Convert.ToString(ids.Question);
int c = Convert.ToInt32(ids.idMain);

Image1.ImageUrl = "~/handler1.ashx?idMain" + c;

-----------------------and handler1.ashx code:


public class handler1 : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
SqlDataReader rdr;

SqlConnection conn = new SqlConnection("Data Source=WIN-MFKUGM21HBL\\SQLEXPRESS;Initial Catalog=OnLineTest;Integrated Security=True");

try
{
var pic_query = "SELECT Image1 FROM SessionQuestion WHERE idMain=" + context.Request.QueryString["idMain"].ToString() + "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = (pic_query);
cmd.Connection = conn;
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{

context.Response.ContentType = "image/jpeg";

if (rdr["Image1"] != DBNull.Value)
{
context.Response.BinaryWrite((Byte[])rdr["Image1"]);
// context.Response.Write((Byte[])rdr["Image1"]);
}

}

if (rdr != null)
rdr.Close();
}
catch { }
finally
{
if (conn != null)
conn.Close();
}
}

public bool IsReusable
{
get
{
return false;
}
}
}