出口的GridView数据到CSV文件 [英] Export gridview data into CSV file
问题描述
我在ASP.Net 2.0 GridView控件,我需要这个GridView的数据导出为CSV文件。
I have a gridview control in ASP.Net 2.0 and i need to export this gridview data into CSV file.
我这个绑定GridView控件与dataset.After数据集绑定到GridView我做像如果我在数据集中得到0 GridView的数据的一些变化,然后我显示0在GridView为已启动,如果我有1数据集中,然后我给1为在GridView未启动。
I have bind this gridview with the dataset.After binding the dataset to the gridview i have done some changes in the gridview data like if I got 0 in dataset then i show 0 as "Started" in the gridview and if i got 1 in the dataset then I show 1 as "Not Started" in the gridview.
所以,我不能直接导出使用的数据集。我需要的是.. 我想code(在C#)的导出我的GridView的数据(而不是数据集的数据)为CSV文件。
So, i can't use dataset directly for exporting. What i need is..i want the code (in c#) that export my gridview data(not dataset's data) into CSV file.
推荐答案
尝试以下code,我用它已经很多次了。它会直接将数据从gridview的出口在code指定的CSV文件。
Try following code, i used it already many times. It will export the data directly from gridview to csv file specified in the code.
protected void btnExportCSV_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";
GridView1.AllowPaging = false;
GridView1.DataBind();
StringBuilder sb = new StringBuilder();
for (int k = 0; k < GridView1.Columns.Count; k++)
{
//add separator
sb.Append(GridView1.Columns[k].HeaderText + ',');
}
//append new line
sb.Append("\r\n");
for (int i = 0; i < GridView1.Rows.Count; i++)
{
for (int k = 0; k < GridView1.Columns.Count; k++)
{
//add separator
sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
}
//append new line
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
有关更多信息,请访问<一个href=\"http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx\">Here
希望它会帮助你。
for more information visit Here Hope it will help you
这篇关于出口的GridView数据到CSV文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!