西夏普的部落格

1.前言
C#的WinForm設計中，報表的開發常涉及到將資料表輸出為CVS格式的檔案。

2.說明
選擇指定輸出檔案路徑，輸出為CVS格式檔案。

using System.Data;
using System.IO;

public void SaveToCSV(DataTable oTable, string FilePath)
{
	string data = "";
	StreamWriter wr = new StreamWriter(FilePath, false, System.Text.Encoding.Default);
	foreach (DataColumn column in oTable.Columns)
	{
		data += column.ColumnName + ",";
	}
	data += "\n";
	wr.Write(data);
	data = "";

	foreach (DataRow row in oTable.Rows)
	{
		foreach (DataColumn column in oTable.Columns)
		{
			data += row[column].ToString().Trim() + ",";
		}
		data += "\n";
		wr.Write(data);
		data = "";
	}
	data += "\n";

	wr.Dispose();
	wr.Close();
}

3.應用

SaveToCSV(myDataTable, "D:\\Temp\\test.csv");