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