TeamAAS-VP-HeShuo/TeamAAS-VM/Data/DataTableHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TeamAAS_VM.Data
{
    /// <summary>
    /// 将DataTable导出到本地文件中
    /// </summary>
    public static class DataTableHelper
    {
        /// <summary>
        /// 将DataTable导出到csv文件中
        /// </summary>
        /// <param name="dataTable"></param>
        /// <param name="filePath"></param>
        public static void ExportToCsv(System.Data.DataTable dataTable, string filePath)
        {
            StringBuilder sb = new StringBuilder();
            //添加列名
            foreach (System.Data.DataColumn column in dataTable.Columns)
            {
                sb.Append(column.ColumnName + ",");
            }
            sb.AppendLine();
            //添加数据
            foreach (System.Data.DataRow row in dataTable.Rows)
            {
                foreach (var item in row.ItemArray)
                {
                    sb.Append(item.ToString() + ",");
                }
                sb.AppendLine();
            }
            System.IO.File.WriteAllText(filePath, sb.ToString());
        }
    }
}