asp.net显示用户信息

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

web.config

 1 <?xml version="1.0" encoding="utf-8"?>
 2 
 3 <!--
 4   有关如何配置 ASP.NET 应用程序的详细信息，请访问
 5   http://go.microsoft.com/fwlink/?LinkId=169433
 6   -->
 7 
 8 <configuration>
 9 
10   <system.web>
11     <compilation debug="true" targetFramework="4.5" />
12     <httpRuntime targetFramework="4.5" />
13   </system.web>
14   <connectionStrings>
15     <add connectionString="Data Source = .; Initial Catalog = mysql; Integrated Security = True;" name="conStr" />
16 
17   </connectionStrings>
18 </configuration>

UserInfo.html

 1 <!DOCTYPE html>
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5     <title>用户信息</title>
 6     <link href="tableStyle.css" rel="stylesheet" />
 7 </head>
 8 <body>
 9     <table>
10         <tr>
11             <th>id</th>
12             <th>姓名</th>
13             <th>邮箱</th>
14             <th>地址</th>
15         </tr>
16         $tbody
17     </table>
18 </body>
19 </html>

UserInfo.ashx

 1 <%@ WebHandler Language="C#" Class="UserInfo" %>
 2 
 3 using System;
 4 using System.Web;
 5 using System.Configuration;
 6 using System.Data.SqlClient;
 7 using System.Data;
 8 using System.IO;
 9 using System.Text;
10 
11 public class UserInfo : IHttpHandler
12 {
13 
14     public void ProcessRequest(HttpContext context)
15     {
16         context.Response.ContentType = "text/html";
17         context.Response.Write("Hello World");
18         //连接字符串
19         string str = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
20         
21         using (SqlConnection con = new SqlConnection(str))
22         {
23             //获取数据库表格
24             using (SqlDataAdapter sda = new SqlDataAdapter("select * from student", con))
25             {
26                 //定义表格dt
27                 DataTable dt = new DataTable();
28                 //将数据库的表格存入dt
29                 sda.Fill(dt);
30                 //定义sb来循环接收字符串
31                 StringBuilder sb = new StringBuilder();
32                 for (int i = 0; i < dt.Rows.Count; i++)
33                 {
34                     //遍历表格dt，将每行数据作为字符串存入sb
35                     sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><tr>",
36                         dt.Rows[i]["id"].ToString(), dt.Rows[i]["name"].ToString(), dt.Rows[i]["email"].ToString(), dt.Rows[i]["address"].ToString());
37                 }
38                 //获取html路径
39                 string path = context.Request.MapPath("UserInfo.html");
40                 //获取html内容
41                 string contentHtml = File.ReadAllText(path);
42                 //把占位符部分替换
43                 contentHtml = contentHtml.Replace("$tbody", sb.ToString());
44                 //输出网页
45                 context.Response.Write(contentHtml);
46             }
47 
48         }
49     }
50 
51     public bool IsReusable
52     {
53         get
54         {
55             return false;
56         }
57     }
58 
59 }

表格css样式

 1         caption
 2         {
 3             padding: 0 0 5px 0;
 4             width: 700px;
 5             font: italic 11px "Trebuchet MS" , Verdana, Arial, Helvetica, sans-serif;
 6             text-align: right;
 7         }
 8         
 9         th
10         {
11             font: bold 11px "Trebuchet MS" , Verdana, Arial, Helvetica, sans-serif;
12             color: #burlywood;
13             border-right: 1px solid #C1DAD7;
14             border-left: 1px solid #C1DAD7;
15             border-bottom: 1px solid #C1DAD7;
16             border-top: 1px solid #C1DAD7;
17             letter-spacing: 2px;
18             text-transform: uppercase;
19             text-align: left;
20             padding: 6px 6px 6px 12px;
21             background: #0066AA no-repeat;
22         }
23         
24         th.nobg
25         {
26             border-top: 0;
27             border-left: 0;
28             border-right: 1px solid #C1DAD7;
29             background: none;
30         }
31         
32         td
33         {
34             border-left: 1px solid #C1DAD7;
35             border-right: 1px solid #C1DAD7;
36             border-bottom: 1px solid #C1DAD7;
37             background: #fff;
38             font-size: 11px;
39             padding: 6px 6px 6px 12px;
40             color: #4f6b72;
41         }
42         
43         
44         td.alt
45         {
46             background: #F5FAFA;
47             color: #797268;
48         }
49         
50         th.spec
51         {
52             border-left: 1px solid #C1DAD7;
53             border-top: 0;
54             background: #fff no-repeat;
55             font: bold 10px "Trebuchet MS" , Verdana, Arial, Helvetica, sans-serif;
56         }
57         
58         th.specalt
59         {
60             border-left: 1px solid #C1DAD7;
61             border-top: 0;
62             background: #f5fafa no-repeat;
63             font: bold 10px "Trebuchet MS" , Verdana, Arial, Helvetica, sans-serif;
64             color: #797268;
65         }
66         
67         .span_link
68         {
69             cursor:pointer;
70             color:Black;
71         }
72         
73         .tr_Category
74         {
75         }
76       
77         .pageLink
78         {
79             color:Blue;
80              margin-left:2px;
81             margin-right:2px;
82         }
83         
84         .tr_Category_P td
85         {
86            background-color:#EEEEFF;
87         }
88        
89