sql server数据库表导出Excel

自己在做网站时遇到的问题，解决后在这里分享一下，有问题的话欢迎提问 ！

 

#region 导出按钮功能
        protected void BtnOut_Click(object sender, EventArgs e)//导出功能
        {
           // Response.Write("<script language=javascript> alert('你好，看呵呵');</script>");//测试语句

            Response.ClearContent();
            //string filename = Server.HtmlEncode("项目清单");
            Response.AddHeader("content-disposition", "attachment; filename=StudentInfo.xls");
            Response.ContentType = "application/excel";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            if (ExportExcel() != null && ExportExcel() != "")
            {
                HttpContext.Current.Response.Write(ExportExcel());
            }

            HttpContext.Current.Response.End();
        }
        public string ExportExcel()                         //根据需要到处的数据库表的字段编写表格
        {

            StringBuilder html = new StringBuilder();
            html
                .Append("<meta http-equiv = \"content-type\" content = \"text/html;charset = uft-8\">")
                .Append("<table cellspacing = \"0\" border = \"1\" >")
                .Append("<tr align = Center style = \"height:24px;\"><td colSpan=\"6\">学生基本信息表</td></tr>")
                .Append("<tr align = Center style = \"height:24px;\">")
                .Append("<td>身份证号</td>")
                .Append("<td>姓名</td>")
                .Append("<td>系部编号</td>")
                .Append("<td>专业编号</td>")
                .Append("<td>班级编号</td>")
                .Append("<td>出生日期</td>")
                .Append("<td>性别</td>")
                .Append("<td>民族</td>")
                .Append("<td>考生类别</td>")
                 .Append("<td>考生号</td>")
                .Append("<td>学号</td>")
                .Append("<td>财务编号</td>")
                .Append("<td>政治面貌</td>")
                .Append("<td>家庭住址</td>")
                .Append("<td>在校表现</td>")

                .Append("</tr>");

            // 获取 dataview dv --------------------
            string aa = "";
            DataView dv = bll.GetList(aa).Tables[0].DefaultView;

            //------------------------------
            for (int i = 0; i < dv.Count; i++)
            {
                html
                    .Append("<tr align = Center style = \"height:24px;\">")
                    .Append("<td>" + dv[i]["CardID"].ToString() + "</td>")//序列号
                    .Append("<td>" + dv[i]["StuName"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["DepID"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["ProID"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["ClaID"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["StuBirthday"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["StuSex"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["StuNation"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["StuType"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["stuTestNum"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["StuNumber"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["FinanceID"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["PoliticsStatus"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["HomePlace"].ToString() + "</td>")//
                    .Append("<td>" + dv[i]["SchoolDisplay"].ToString() + "</td>")//                  
                    .Append("</tr>");
            }
            html.Append("</table>");
            return html.ToString();
        }

        #endregion