将Tab分隔/带换行符的.txt文件导入DataGrid(View)

private DataTable TxtToDataSet(string Filename)
{
   DataSet ds=new DataSet();
   DataTable output=new DataTable("student");
   try
   {
    // Create an instance of StreamReader to read from a file.
    // The using statement also closes the StreamReader.
    
    
    StreamReader sr = new StreamReader(Filename);
    
    String line;
    // Read and display lines from the file until the end of
    // the file is reached.
    if((line = sr.ReadLine())!=null)
    {
     string[] strs=line.Split('\t');
     foreach(string s in strs)
      output.Columns.Add(s); 
    }
    DataRow myRow;
    while ((line = sr.ReadLine()) != null)
    {
     myRow = output.NewRow();

     string[] strs=line.Split('\t');
     int i=0,j=0,linelength=strs.Length;
     
     foreach(string s in strs)
     {
      myRow[j++]=s;
      if (j==linelength)
      {
       j=0;
       i++;
      }
     }
     output.Rows.Add(myRow);
    }
    
    ds.Tables.Add(output);
   }

   catch (Exception e)
   {
    // Let the user know what went wrong.
    MessageBox.Show("The file could not be read:");
    MessageBox.Show(e.Message);
   }
   //return ds;
   return output;

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值