将DataTable导出为excel

 

本小节主要介绍如何将DataTable表中的数据导入到excel中去。主要是先通过将DataTable数据表中的数据绑定到GridView上，在将GridView中的数据到处成excel的形式。

    实例代码如下：

    string sConnectionString; //声明一个字符串
        //连接数据库字符串，连接到XBMIS数据库，用户名是sa
        sConnectionString = " Data Source=.;Initial Catalog=XBMIS;User ID=sa; ";
        //创建SqlConnection数据库连接对象
        SqlConnection Conn = new SqlConnection(sConnectionString);
        //打开Conn
        Conn.Open();
        //sql语句把T_YongH表中的数据信息都取出来
        string commandString = "Select BianH AS 编号,ZhuCYHM AS 注册名,XingM AS 姓名,XingB AS 性别 From T_YongH";
        SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, Conn);
        ds_datatable ds = new ds_datatable();
        //填充数据集
        dataAdapter.Fill(ds, "YongH");
        DataTable dataTable1 = ds.Tables["YongH"];
        Response.Clear();
        Response.Buffer = true;
        //Response.ContentType = "application/vnd.ms-excel";
        Response.ContentType = "application/vnd.ms-word";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.Charset = "";
        this.EnableViewState = false;
        StringWriter oStringWriter = new StringWriter();
        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
        DataGrid dg = new DataGrid();
        dg.DataSource = dataTable1; //返回DataTable
        dg.DataBind();
        dg.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();