当前位置：文江博客话题详情

使用 Winforms（内置）导出到 CSV

发布于 2024-09-10 00:47:41 字数 58 浏览 2 评论 0原文

有没有办法使用 .NET 2.0 Winforms 实现从数据网格导出 csv？

谢谢

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

茶底世界 2024-09-17 00:47:41

没有内置任何东西，但自己做起来相当简单。

// Create the CSV file to which grid data will be exported.
StreamWriter sw = new StreamWriter("~/GridData.txt", false);

DataTable dt = GetDataTable(); // Pseudo code

// First we will write the headers.
sw.WriteLine(string.Join(",", dt.Columns.Select(c => c.ColumnName)));

// Now write all the rows.
int iColCount = dt.Columns.Count;
foreach (DataRow dr in dt.Rows)
{
    List<string> columnData = new List<string>();
    for (int i = 0; i < iColCount; i++)
    {
        if (!Convert.IsDBNull(dr[i]))
        {
            columnData.Add(dr[i].ToString());
        }
        else
        {
            columnData.Add(string.Empty);
        }
    }
    sw.WriteLine(string.Join(",", columnData.ToArray()));
}

sw.Close();

当然可以对此代码进行进一步的优化和改进。我对写出行的代码不满意。

There's nothing built in, but it's fairly straightforward to do yourself.

// Create the CSV file to which grid data will be exported.
StreamWriter sw = new StreamWriter("~/GridData.txt", false);

DataTable dt = GetDataTable(); // Pseudo code

// First we will write the headers.
sw.WriteLine(string.Join(",", dt.Columns.Select(c => c.ColumnName)));

// Now write all the rows.
int iColCount = dt.Columns.Count;
foreach (DataRow dr in dt.Rows)
{
    List<string> columnData = new List<string>();
    for (int i = 0; i < iColCount; i++)
    {
        if (!Convert.IsDBNull(dr[i]))
        {
            columnData.Add(dr[i].ToString());
        }
        else
        {
            columnData.Add(string.Empty);
        }
    }
    sw.WriteLine(string.Join(",", columnData.ToArray()));
}

sw.Close();

There are certainly further optimisations and improvements that can be made to this code. I'm not happy with the code that writes out the rows.

回复收藏 0 原文

~没有更多了~