将DataTable 导出为csv
//测试用的 导出查询的DataTable
public static void Export(DataTable dtResult) { string strHeader =null; string LogName=@"d:\code\tableLog.csv"; for (int i = 0; i < dtResult.Columns.Count; i++) { strHeader += dtResult.Columns[i].ColumnName + ","; } strHeader= strHeader.Substring(0, strHeader.Length - 1)+"\r\n"; File.AppendAllText(LogName, strHeader); for (int i = 0; i < dtResult.Rows.Count; i++) { strHeader = null; for (int j = 0; j< dtResult.Columns.Count; j++) { strHeader += dtResult.Rows[i][j]+ ","; } strHeader = strHeader.Substring(0, strHeader.Length - 1) + "\r\n"; File.AppendAllText(LogName, strHeader); } }
strHeader 最好改为 StringBuilder 。