使用 CsvHelper 将数据表导出到 CSV

 

private void btnExportData_Click(object sender, EventArgs e)
{
    using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "CSV files|*.csv" })
    {
        if (sfd.ShowDialog() == DialogResult.OK)
        {
            try
            {
                using (var textWriter = File.CreateText(sfd.FileName))
                {
                    using (CsvWriter csv = new CsvWriter(textWriter, System.Globalization.CultureInfo.CurrentCulture))
                    {
                        DataTable dt = this.appData.Customers.CopyToDataTable();
                        // Write columns
                        foreach (DataColumn column in dt.Columns)
                            csv.WriteField(column.ColumnName);
                        csv.NextRecord();
                        // Write row values
                        foreach (DataRow row in dt.Rows)
                        {
                            for (var i = 0; i < dt.Columns.Count; i++)
                                csv.WriteField(row[i]);
                            csv.NextRecord();
                        }
                    }
                }
                MessageBox.Show("You have successfully exported the file.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}

 

福克斯学习|Windows Forms： 如何在 C 语言中使用 CsvHelper 将数据表导出到 CSV# (foxlearn.com)