将gridview的内容导出到excel中去

 asp.net 2.0中,gridview控件是个很不错的控件,如何将gridview中的数据导出到EXCEL中去呢?特别是当gridview中的数据是分页显示时,要将整个gridview的数据导出到EXCEL中去呢?下面是解决的办法:
下面是部分代码片段:
defualt.aspx中,添加一个gridview控件
  <form id="form1" runat="server">
    <div>
        &nbsp;
        <asp:GridView ID="GridView1" runat="server" AllowPaging="true" OnPageIndexChanging="paging">
        </asp:GridView>
   
    </div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出到excel" />
    </form>

default.aspx
  protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindData();
        }

    }
   
    private void BindData()
    {
        // make the query
        string query = "SELECT * FROM customers";
        SqlConnection myConnection = new SqlConnection(ConnectionString);
        SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);
        DataSet ds = new DataSet();
        ad.Fill(ds, "customers");
        GridView1.DataSource = ds;
        GridView1.DataBind();

   }


    public override void VerifyRenderingInServerForm(Control control)
    {

        // Confirms that an HtmlForm control is rendered for

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();

        Response.AddHeader("content-disposition",
        "attachment;filename=FileName.xls");

        Response.Charset = "gb2312";
        Response.ContentType = "application/vnd.xls";

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter htmlWrite =
        new HtmlTextWriter(stringWrite);

       
        GridView1.AllowPaging = false;
        BindData();
        GridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());

        Response.End();

        GridView1.AllowPaging = true;
        BindData();

    }
    protected void paging(object sender,GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        BindData();
    }

阅读更多
个人分类: asp.net
上一篇asp.net收集
下一篇asp.net 2.0中gridview里嵌套dropdownlist
想对作者说点什么? 我来说一句

GridView显示的内容导出为Excel

2009年10月13日 33KB 下载

没有更多推荐了,返回首页

关闭
关闭