DataGrid数据导出为xls,htm格式文件

最新推荐文章于 2018-10-19 22:33:00 发布

zj1103

最新推荐文章于 2018-10-19 22:33:00 发布

阅读量337

点赞数

分类专栏： ASP.NET经验整理文章标签： datagrid dataset table database button object

本文链接：https://blog.csdn.net/zj1103/article/details/4049993

版权

ASP.NET经验整理专栏收录该内容

70 篇文章 0 订阅

订阅专栏

protected void Button1_Click(object sender, EventArgs e)
    {
        DataGrid dg = new DataGrid();
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dsn"]);
        SqlDataAdapter da = new SqlDataAdapter("select databaseID,typeID,dbName from ds_database", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "table1");
        DataTable dt = ds.Tables["table1"];
        dg.DataSource = dt.DefaultView;
        dg.DataBind();
        Response.Clear();
        Response.Buffer = false;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=test.xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel"; this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        this.DataGrid1.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataGrid dg = new DataGrid();
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dsn"]);
        SqlDataAdapter da = new SqlDataAdapter("select databaseID,typeID,dbName from ds_database", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "table1");
        DataTable dt = ds.Tables["table1"];
        dg.DataSource = dt.DefaultView;
        dg.DataBind();
        dg.HeaderStyle.BackColor = System.Drawing.Color.Blue;
        Response.Clear();
        Response.Buffer = false;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=test.htm");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel"; this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        dg.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }