1 <%@ WebHandler Language="C#" Class="List" %> 2 3 using System; 4 using System.Web; 5 6 7 using System.Data; 8 using System.Data.SqlClient; 9 using System.Text; 10 using System.IO; 11 12 public class List : IHttpHandler { 13 14 public void ProcessRequest (HttpContext context) { 15 //context.Response.ContentType = "text/plain"; 16 //context.Response.Write("Hello World"); 17 DataTable dt = LoadData(); 18 StringBuilder sb = new StringBuilder("<table style = \"border:1px\">"); 19 foreach(DataRow dr in dt.Rows) 20 { 21 sb.Append("<tr>"); 22 sb.Append("<td>"+ dr[0]+"</td>"); 23 sb.Append("<td>"+ dr[1]+"</td>"); 24 sb.Append("<td>"+ dr[2]+"</td>"); 25 sb.Append("<td><a href='del.ashx?id="+dr[0].ToString()+"'>删除</a></td>"); 26 sb.Append("</tr>"); 27 } 28 sb.Append("</table>"); 29 string strPath = context.Server.MapPath("./HtmlModel.htm"); 30 string strHtml = File.ReadAllText(strPath); 31 strHtml= strHtml.Replace("@title","欢迎查看学生列表页"); 32 strHtml= strHtml.Replace("@body", sb.ToString()); 33 context.Response.Write(strHtml); 34 } 35 36 private DataTable LoadData() 37 { 38 DataTable dt = null; 39 try 40 { 41 SqlConnection conn = new SqlConnection("Data Source=PC--20130405SCI\\YAOSIR;Initial Catalog=Clients;User ID= sa;Password=123456"); 42 43 conn.Open(); 44 SqlCommand cmd = new SqlCommand(); 45 46 cmd.CommandText = "Select * from OrderClient"; 47 48 cmd.Connection = conn; 49 SqlDataReader dr = cmd.ExecuteReader(); 50 //SqlDataAdapter da = new SqlDataAdapter(selectStr,conn); 51 dt = new DataTable(); 52 dt.Load(dr); 53 54 55 //string sqlStr = "Select * from OrderClient"; 56 //SqlDataAdapter da = new SqlDataAdapter(sqlStr, conn); 57 //dt = new DataTable(); 58 //da.Fill(dt); 59 } 60 catch (Exception e ) 61 { 62 63 throw new Exception("执行出现异常..."); 64 } 65 66 return dt; 67 } 68 69 public bool IsReusable { 70 get { 71 return false; 72 } 73 } 74 75 }
点击“删除”跳转到del.ashx页面
1 <%@ WebHandler Language="C#" Class="del" %> 2 3 using System; 4 using System.Web; 5 using System.Data; 6 using System.Data.SqlClient; 7 8 public class del : IHttpHandler { 9 10 public void ProcessRequest (HttpContext context) { 11 //context.Response.ContentType = "text/plain"; 12 //context.Response.Write("Hello World"); 13 string sid = context.Request.QueryString["id"]; 14 if (sid != null) 15 { 16 int ID = -1; 17 if (int.TryParse(sid, out ID)) 18 { 19 if (DoDel(ID)) 20 { 21 context.Response.Write("删除成功!"); 22 } 23 else 24 { 25 context.Response.Write("删除失败!"); 26 } 27 } 28 else 29 { 30 context.Response.Write("主键转换失败...."); 31 } 32 } 33 else 34 { 35 context.Response.Write("未获取主键值!"); 36 } 37 } 38 private bool DoDel(int id) 39 { 40 string connStr = "Data Source=PC--20130405SCI\\YAOSIR;Initial Catalog=Clients;User ID= sa;Password=123456"; 41 SqlConnection conn = new SqlConnection(connStr); 42 conn.Open(); 43 string sqlStr = "delete from OrderClient where ClientID = @sid"; 44 SqlCommand cmd = new SqlCommand(sqlStr, conn); 45 SqlParameter par = new SqlParameter("@sid",id); 46 cmd.Parameters.Add(par); 47 int result = cmd.ExecuteNonQuery(); 48 49 return result>0; 50 } 51 52 public bool IsReusable { 53 get { 54 return false; 55 } 56 } 57 58 }