Hello. for showing photo in my site. i am using Handler(.NET 3.5) to read from DB a and show it in DataList. But when i uploaded the site photos are shown slow.
Please look at the site:
http://omed-ltd.com/[
^]
omed-ltd.com
and the code that i am using:
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Data.SqlClient;
public class Handler : IHttpHandler {
SqlConnection myConnection;
SqlCommand cmd;
public Handler()
{
myConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["myDB"].ConnectionString);
cmd = new SqlCommand("", myConnection);
myConnection.Open();
}
public void ProcessRequest (HttpContext context) {
try
{
string sql = "Select TPImage,id,Image_Type from TProduct where Id=@Id";
cmd.CommandText = sql;
cmd.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = context.Request.QueryString["Id"];
cmd.Prepare();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
context.Response.ContentType = dr["Image_Type"].ToString();
context.Response.BinaryWrite((byte[])dr["TPImage"]);
dr.Close();
myConnection.Close();
}
catch (Exception ex)
{
}
}
public bool IsReusable {
get {
return false;
}
}
}
Thank you.