将gridview的内容导出到excel中去.txt

ASP.NET学习大全(高手整理)。。。。。。。。。。。共同学习

将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();
}