static readonly string tabletemplate = @"<table id=""dbt"" runat=""server"">
<tr>
<td>
<table border=""1"" cellpadding=""0"" cellspacing=""0"">
<tr><td>ç¼å·</td><td>å¸å·</td><td>çå®å§å</td><td>å¹´é¾</td><td>æ§å«</td><td>ææº</td><td>çµè¯</td><td>çµåé®ä»¶</td></tr>
{0}
</table> ";
protected String ShowData()
{
//å®ä¾åConnection对象
SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=AspNetStudy;Persist Security Info=True;User ID=sa;Password=sa");
//å®ä¾åCommand对象
SqlCommand command = new SqlCommand("select * from UserInfo where sex=0", connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
/*
ä¸é¢ç被注éæç代ç ä¸ä¸é¢ç代ç æ¯çæç
SqlDataAdapter adapter = new SqlDataAdapter("select * from UserInfo where sex=0", connection);
*/
DataTable data = new DataTable();
adapter.Fill(data);
/* ä¸é¢ç被注éæè¯å¥ä¸ä¸é¢å¡«å
DataTableçæææ¯ä¸æ ·çï¼ææ´å¾åäºæ²¡æ注éæçé¨å
DataSet ds = new DataSet();//å®ä¾åDataSet
adapter.Fill(ds, "UserInfo");//å¡«å
dsä¸ç"UserInfo"表
DataTable data = ds.Tables["UserInfo"];
*/
StringBuilder sb = new StringBuilder();
for (int i = 0; i < data.Rows.Count; i++)
{
sb.Append("<tr><td>" + data.Rows[i]["UserId"].ToString() + "</td>");
sb.Append("<td>" + data.Rows[i]["UserName"].ToString() + "</td>");
sb.Append("<td>" + data.Rows[i]["RealName"].ToString() + "</td>");
sb.Append("<td>" + data.Rows[i]["Age"].ToString() + "</td>");
//ä¸é¢æ¯æç
§å顺åºç´æ¥è¯»åå¼ï¼å¹¶ä¸æ ¹æ®å¼æ¥å¤ææç»æ¾ç¤ºç»æ
sb.Append("<td>" + (bool.Parse(data.Rows[i]["Sex"].ToString()) == true ? "ç·" : "女") + "</td>");
//æ ¹æ®å顺åºè¯»ï¼åçå¼éè¦åç¸åºè½¬æ¢
sb.Append("<td>" + data.Rows[i]["Mobile"].ToString() + "</td>");
//æ ¹æ®ååæ¥è¯»åï¼åçå¼éè¦åç¸åºè½¬æ¢
sb.Append("<td>" + data.Rows[i]["Phone"].ToString() + "</td>");
sb.Append("<td>" + data.Rows[i]["Email"].ToString() + "</td></tr>\n");
}
String s = tabletemplate.Replace("{0}", sb.ToString());
return s;
}
protected void Button1_Click(object sender, EventArgs e)
{
Export("application/ms-excel", "xnjs.xls");
}
private void Export(string Filetype, string FileName)
{
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlDecode(FileName, Encoding.UTF8).ToString());
Response.ContentType = Filetype;
this.EnableViewState = false;
Response.Write(ShowData());
Response.End();
}
温馨提示:内容为网友见解,仅供参考