DataGrid 转 CSV 文件 [英] DataGrid to CSV file

问题描述

我正在将 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屋！