asp.net一般处理程序(2)获取列表
将数据库中的内容显示出来
1.添加文件 List.ashx
代码如下
public class List : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
DataTable dt = LoadData();
StringBuilder sb = new StringBuilder();
sb.AppendLine("<table id=\"tStus\">");
foreach (DataRow dr in dt.Rows)
{
sb.AppendLine("<tr>");
sb.AppendLine("\t<td>" + dr["Id"].ToString() + "</td>");
sb.AppendLine("\t<td>" + dr["Name"].ToString() + "</td>");
sb.AppendLine("\t<td>" + dr["Address"].ToString() + "</td>");
sb.AppendLine("</tr>");
}
sb.AppendLine("</table>");
string strPath = context.Server.MapPath("./ListModel.htm");
string strHTML = System.IO.File.ReadAllText(strPath);
strHTML = strHTML.Replace("@title", "学生列表");
strHTML = strHTML.Replace("@body", sb.ToString());
context.Response.Write(strHTML);
}
/// <summary>
/// 获取列表数据
/// </summary>
private DataTable LoadData()
{
string strConn = @"Data Source=ADMINPC;Initial Catalog=School;Integrated Security=True";
string strSQL = "select * from T_Students";
using (SqlConnection conn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
2.添加 ListModel.htm
代码如下
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>@title</title>
</head>
<body>
@body
</body>
</html>