這裡是和griffiponx80@outlook.com有關的地盤,歡迎到訪我的BLOG!

DataTable dt = TxtConvertToDataTable(fileName, "tmp", ",");

public DataTable TxtConvertToDataTable(string File翻譯社 string TableName翻譯社 string delimiter)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
StreamReader s = new StreamReader(File翻譯社 System.Text.Encoding.Default);
//string ss = s.ReadLine();//skip the first line
string[] columns = s.ReadLine().Split(delimiter.ToCharArray());
ds.Tables.Add(TableName);
foreach (string col in columns)
{
bool added = false;
string next = "";
int i = 0;
while (!added)
{
string columnname = col + next;
columnname = columnname.Replace("#", "");
columnname = columnname.Replace("'", "");
columnname = columnname.Replace("&", "");

if (!ds.Tables[TableName].Columns.Contains(columnname))
{
ds.Tables[TableName].Columns.Add(columnname.ToUpper());
added = true;
}
else
{
i++;
next = "_" + i.ToString();
}
}
}

string AllData = s.ReadToEnd();
string[] rows = AllData.Split("
".ToCharArray());

foreach (string r in rows)
{
string[] items = r.Split(delimiter.ToCharArray());
ds.Tables[TableName].Rows.Add(items);
}

s.Close();

dt = ds.Tables[0];

return dt;
}

3.運用

1.前言

2.申明
文字檔案例如CSV花式是以逗號區隔資料，利用StreamReader讀取資料寫入DataTable中。