将dataset导出excel文件

  public static DataSet Query(string SQLString)
       {
           using (SqlConnection connection = new SqlConnection(ConnectionString))
           {
               DataSet ds = new DataSet();
               try
               {
                   connection.Open();
                   SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
                   command.Fill(ds, "ds");
               }
               catch (System.Data.SqlClient.SqlException ex)
               {
                   throw new Exception(ex.Message);
               }
               return ds;
           }
       }

上面代码为执行SQL语句，反回dataset类型出来

 DataSet ds = Pagin.Query(strsql);

   public void EasyExportExcel(HttpResponse resp)
        {
            resp.Charset = "gb2312";
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls");
            resp.ContentType = "applicationnd.ms-excel";

            string herd = "<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=GB2312\"/>";

            StringBuilder table = new StringBuilder();
            table.Append("<table border='1'>");

            #region 设置表头

            table.Append("<tr>");

            for (int i = 0; i < this.Data.Columns.Count; i++)
            {
                table.Append("<th>" + this.Data.Columns[i].ColumnName + "</th>");
            }

            table.Append("</tr>");

            #endregion

            table.Append("</table>");

            resp.Write(herd + table);
            resp.Flush();
            resp.End();
        }

export.EasyExportExcel(this.Response);

即可导出 EXCEL