Normal
0
false
false
false
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:”";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
Create a file Handler.ahx
<%@ WebHandler
Language=”C#”
Class=”Handler”
%>
using
System;
using
System.Data;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
System.Data;
using
System.Data.SqlClient;
using
System.IO;
public
class Handler : IHttpHandler
{
public void ProcessRequest(HttpContext
context)
{
SqlConnection
myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["connection"].ToString();
myConnection.Open();
string sql = “Select * from
guest.Photos where Pic_ID=@Pic_ID“;
SqlCommand cmd = new SqlCommand(sql,
myConnection);
cmd.Parameters.Add(“@Pic_ID”,
SqlDbType.Int).Value = context.Request.QueryString["id"];