读书人

从TXT读取依存入到DataTable

发布时间: 2012-12-28 10:29:04 作者: rapoo

从TXT读取并存入到DataTable
求完整从TXT读取并存入到DataTable的代码,以逗号为分割符,TXT中的数据例如:
————————
1,105.64,38.65
2,106.05,38.72
————————
谢谢。
[解决办法]


static void Main(string[] args)
{
#region 读取字符串

StreamReader sr = new StreamReader("c:\\bb.txt", Encoding.GetEncoding("GB2312"));
string txt = sr.ReadToEnd().Replace("\r\n","-");
string[] nodes = txt.Split('-');

#endregion

#region 填充DataTable

DataTable dt = new DataTable();

dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Field1", typeof(double));
dt.Columns.Add("Field2", typeof(double));

foreach (string node in nodes)
{
string[] strs = node.Split(',');
DataRow dr = dt.NewRow();
dr["ID"] = strs[0];
dr["Field1"] = strs[1];
dr["Field2"] = strs[2];

dt.Rows.Add(dr);
}

#endregion
sr.Close();

}


[解决办法]
文本文件如楼主给出的:
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(int));
dt.Columns.Add("经度", typeof(double));
dt.Columns.Add("纬度", typeof(double));
string[] rows = File.ReadAllLines(@"c\test.txt"));
foreach (string row in rows)
dt.Rows.Add(row.Split(','));
dataGridView1.DataSource = dt;

读书人网 >C#

热点推荐