1. “sb.Append("\"" + table.Columns[i].ColumnName + "\"" + ",");” 如果这里的前后两边不添加“\"”,就会乱,但是不知道为什么!!!!!如果有幸被哪位高手看到,就请帮帮忙吧
public static void saveDataTableToCsv(System.Data.DataTable table, string file)
{FileStream fs = new FileStream(file, FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < table.Columns.Count; i++)
{
sb.Append("\"" + table.Columns[i].ColumnName + "\"" + ",");
}
sb.Append("\n");
foreach (DataRow row in table.Rows)
{
for (int i = 0; i < table.Columns.Count; i++)
{
sb.Append("\"" + row[i].ToString() + "\"" + ",");
}
sb.Append("\n");
}
sw.Write(sb.ToString());
sw.Close();
fs.Close();
}