asp.net實(shí)現(xiàn)從Txt文件讀取數(shù)據(jù)到數(shù)據(jù)視圖的方法

#region 從Txt文件讀取數(shù)據(jù)到數(shù)據(jù)視圖
/// 從Txt文件讀取數(shù)據(jù)到數(shù)據(jù)視圖
/// /summary>
/// param name="strExcelPath">文件路徑/param>
/// returns>返回一個(gè)數(shù)據(jù)視圖/returns>
public static DataView GetDataFromTxt(string strTxtPath)
{
  string strLine = "";
  DataRow row;
  try
  {
   DataTable tbl = new DataTable();
   StreamReader sr = new StreamReader(strTxtPath, Encoding.GetEncoding("GB2312"));
   strLine = sr.ReadLine(); //讀取第一行列屬性
   string[] Fields = strLine.Split(new char[] { '/t' });//讀取每一個(gè)字段（以TAB分開）
   for (int k = 0; k  Fields.Length; k++) //給表增加列屬性
   {
    tbl.Columns.Add(Fields[k], typeof(string));
   }
   while ((strLine = sr.ReadLine()) != null)
   {
    row = tbl.NewRow();
    string[] words = strLine.Split(new char[] { '/t' });//讀取每一個(gè)字段值（以TAB分開）
    for (int j = 0; j  words.Length; j++)
    {
     row[j] = words[j];
    }
    tbl.Rows.Add(row);
   }
   sr.Dispose();
   sr.Close();
   DataView dv = new DataView(tbl);
   return dv;
  }
  catch
  {
   return null;
  }
}
#endregion