DataGrid的CSV文件 [英] DataGrid to CSV file
本文介绍了DataGrid的CSV文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我绑定一个DataTable到DataGrid,一切工作正常。 我的下一步是在 DataGrid中的数据导出到CSV 文件,以逗号分隔。
I am binding a DataTable to a DataGrid, everything is working fine. My next step is to export the DataGrid data to a CSV file, comma delimited.
什么是这样做的最好/最简单的方法 ASP.Net 3.5
What is the best/easiest way doing this with ASP.Net 3.5?
推荐答案
我用这个片段到DataGrid导出为CSV。也许它可以帮助:
I used this Snippet to export a DataGrid To CSV. Maybe it helps:
public void OnExportGridToCSV(object sender, System.EventArgs e)
{
// Create the CSV file to which grid data will be exported.
StreamWriter sw = new StreamWriter(Server.MapPath("~/GridData.csv"), false);
// First we will write the headers.
DataTable dt = ((DataSet)grid1.DataSource).Tables[0];
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
sw.Write(dt.Columns[i]);
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
// Now write all the rows.
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
if (!Convert.IsDBNull(dr[i]))
{
sw.Write(dr[i].ToString());
}
if (i < iColCount - 1)
{
sw.Write(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator);
}
}
sw.Write(sw.NewLine);
}
sw.Close();
}
这篇关于DataGrid的CSV文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文