如何将 txt 导入 datatable

[tyhuang]

txt 格式如下
11111
22222
3333 333
4444 44444
55555
没有分割符

[qb81195235]

System.IO.TextReader   tr   =   System.IO.File.OpenText("d:\\test123.txt");   
  System.Collections.ArrayList   al   =   new   ArrayList();   
    
  string   tmp   =   tr.ReadLine();   
  while(tmp   !=   null)   
  {   
  al.Add(tmp);   
  tmp   =   tr.ReadLine();   
  }   
    
  tr.Close();   
    
  string[]   txts   =   new   string[al.Count];   
  al.CopyTo(txts,0);

//读取TXT文件每行的数据

[yanlan112]

[Quote=引用 1 楼 qb81195235 的回复:]
C# code
System.IO.TextReader tr = System.IO.File.OpenText("d:\\test123.txt");
System.Collections.ArrayList al = new ArrayList();

string tmp = tr.ReadLine();
while(tmp != null)
{
al.Add(tmp);
tmp = tr.ReadLine();
}

tr.Close();

string[] txts = new string[al.Count];
al.CopyTo(txts,0);
…
[/Quote]

[jiangzhe556]

[Quote=引用 1 楼 qb81195235 的回复:]
C# code
System.IO.TextReader tr = System.IO.File.OpenText("d:\\test123.txt");
System.Collections.ArrayList al = new ArrayList();

string tmp = tr.ReadLine();
while(tmp != null)
{
al.Add(tmp);
tmp = tr.ReadLine();
}

tr.Close();

string[] txts = new string[al.Count];
al.CopyTo(txts,0);
…
[/Quote]
ddd

[wxg22526451]

            //读取所有行
            string[] sarr = File.ReadAllLines(@"c:\123.txt");
            foreach (string s in sarr)
            {
                //添加到DataTable   
            }

[wxg22526451]

没有分割符？怎么区分列？

[tyhuang]

插入一列

[wxg22526451]

一列就好办了。

            //读取所有行
            string[] sarr = File.ReadAllLines(@"c:\123.txt");
            DataTable dt = new DataTable();
            dt.Columns.Add("col1", typeof(string));
            foreach (string s in sarr)
            {
                //添加到DataTable
                dt.Rows.Add(s);
                
            }

[十八道胡同]

[Quote=引用 7 楼 wxg22526451 的回复:]


C# code //读取所有行
string[] sarr = File.ReadAllLines(@"c:\123.txt");
DataTable dt = new DataTable();
dt.Columns.Add("col1", typeof(string));
foreach (string s in sarr)
{
//添加到DataTable
dt.Rows.Add(s);

}
[/Quote]


up up

[wuyq11]

public DataTable DTtxt(string filePath,string fileName)
{
FileStream fs = new FileStream(filePath + "\\" + fileName,FileMode.Open,FileAccess.Read,FileShare.None);
StreamReader sr=new StreamReader(fs,Encoding.GetEncoding("GB2312"));
string StrLine=sr.ReadToEnd();
sr.Close();

string[] ArryList=Regex.Split(StrLine,"\n");

DataTable DT=new DataTable();
DT.Columns.Add("a");
string[] arrylist={};
if(ArryList.Length>0)
{
for(int i=0;i<ArryList.Length;i++)
{
arrylist=ArryList[i].ToString().Split('|');
DT.Rows.Add(arrylist);
}
DT.AcceptChanges();
}
return DT;
}