今天用一般处理程序ashx做一个如下的效果，
主要是为了实现功能，界面丑就丑把。
先是显示界面DomeHandler.ashx
public void ProcessRequest (HttpContext context) {context.Response.ContentType = "text/html";StringBuilder sb = new StringBuilder();//连接字符串string str = System.Configuration.ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString;string sql = "select top(10) ProductID, ProductName, PTID, ProductJP, ProductPrice from Products";using (SqlConnection conn=new SqlConnection(str)){using (SqlCommand cmd=new SqlCommand(sql,conn)){conn.Open();using (SqlDataReader reader= cmd.ExecuteReader()){while (reader.Read()){sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td><a href='ShowDetail.ashx?id={0}'>详情</a><td/><td><a href='DeleteData.ashx?id={0}' onClick='return confirm(\&;是否要删除\&;)'>删除</a><td/><td><a href='Edit.ashx?id={0}'>修改</a><td/></tr>", reader["ProductID"], reader["ProductName"]);}}}}//将虚拟路径转化成绝对路径string path=context.Request.MapPath("/ListHandler.html");string html=System.IO.File.ReadAllText(path);html=html.Replace("@changeStr", sb.ToString());context.Response.Write(html);} 其中的ListHandler.html是一个模板，也就是一个html页面
用占位符将需要替换的字符放在页面中，再用Replace替换数据即可
然后是详情页面ShowDetail.ashx
public void ProcessRequest (HttpContext context) {context.Response.ContentType = "text/html";//获取传过来的参数string id = context.Request.QueryString["id"];int sqlId = int.Parse(id);string str=System.Configuration.ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString;string sql="select ProductID, ProductName, PTID, ProductJP, ProductPrice from Products where ProductID=@id";//可变字符串StringBuilder sb = new StringBuilder();System.Data.DataTable dt = new System.Data.DataTable();using (SqlDataAdapter adapter=new SqlDataAdapter(sql,str)){adapter.SelectCommand.Parameters.Add("@id", sqlId);adapter.Fill(dt);}sb.AppendFormat("<td>{0}</td>", dt.Rows[0]["ProductID"]);sb.AppendFormat("<td>{0}</td>", dt.Rows[0]["ProductName"]);sb.AppendFormat("<td>{0}</td>", dt.Rows[0]["ProductJP"]);sb.AppendFormat("<td>{0}</td>", dt.Rows[0]["ProductPrice"]);//获取另一个页面的内容string path=context.Request.MapPath("/ShowDataDetail.html");string html = File.ReadAllText(path);html = html.Replace("@changeStr", sb.ToString());context.Response.Write(html);}然后是删除页面DeleteData.ashx
public void ProcessRequest (HttpContext context) {context.Response.ContentType = "text/html";//获取IDstring id = context.Request.QueryString["id"];int sqlId;int.TryParse(id, out sqlId);string sql = "delete from Products where ProductID=@id";string str = System.Configuration.ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString;if (sqlId==null){return;}using (SqlConnection conn = new SqlConnection(str)){using (SqlCommand cmd=new SqlCommand(sql,conn)){cmd.Parameters.Add("@id", sqlId);conn.Open();int rows = cmd.ExecuteNonQuery();if (rows > 0){context.Response.Redirect("DomeHandler.ashx");}else{context.Response.Write("删除失败");}}}}最后稍难的修改页面Edit.ashx
public void ProcessRequest (HttpContext context) {context.Response.ContentType = "text/html";//获取是展示还是提交if (context.Request["edit"] == "edit"){string id = context.Request["id"];string productName = context.Request["ProductName"];string productPrice = context.Request["ProductPrice"];int sqlId;int.TryParse(id, out sqlId);if (sqlId == null){return;}string sql = "update Products set ProductName=@ProductName,ProductPrice=@ProductPrice where ProductID=@id";string str = System.Configuration.ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString;using (SqlConnection conn = new SqlConnection(str)){using (SqlCommand cmd = new SqlCommand(sql, conn)){cmd.Parameters.Add("@id", sqlId);cmd.Parameters.Add("@ProductName", productName);cmd.Parameters.Add("@ProductPrice", productPrice);conn.Open();int rows = cmd.ExecuteNonQuery();if (rows > 0){//跳转页面到展示界面context.Response.Redirect("DomeHandler.ashx");}else{context.Response.Write("修改失败");}}}}else{//获取IDstring id = context.Request.QueryString["id"];int sqlId;int.TryParse(id, out sqlId);string sql = "select ProductID, ProductName, ProductPrice from Products where ProductID=@id";string str = System.Configuration.ConfigurationManager.ConnectionStrings["DataBase"].ConnectionString;System.Data.DataTable dt = new System.Data.DataTable();if (sqlId == null){return;}using (SqlDataAdapter adapter = new SqlDataAdapter(sql, str)){adapter.SelectCommand.Parameters.Add("@id", sqlId);adapter.Fill(dt);}string html=System.IO.File.ReadAllText(context.Request.MapPath("Edit.html"));html = html.Replace("@id", dt.Rows[0]["ProductID"].ToString());html = html.Replace("@ProductName", dt.Rows[0]["ProductName"].ToString());html = html.Replace("@ProductPrice", dt.Rows[0]["ProductPrice"].ToString());context.Response.Write(html);}} 再发一下Edit.html
欲望以提升热忱，毅力以磨平高山。
