string[] FieldsInArray ={ "c0", "c1", "c2", "c3", "c4", "c5", "c6", "c7" }; //声明一个字符数组,用于存放列名
DataSet ds = new DataSet();
ds =TextFileLoader(@"D:\cpbuyaa20071018.txt","good",FieldsInArray); //文件路径,表明,列名
dataGridView1.DataSource = ds.Tables[0];
//实现转换的方法
public static DataSet TextFileLoader(string FilePath, string TableName, string[] FieldsInArray)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable(TableName);
FileStream fs = File.Open(FilePath, FileMode.Open, FileAccess.Read);
StreamReader sr = new StreamReader(fs);
for (int i = 0; i < FieldsInArray.Length; i++)
{
dt.Columns.Add(new DataColumn(FieldsInArray[i], typeof(string)));
}
string strRead;
bool flag = true;
while (flag)
{
strRead = sr.ReadLine();
if (!string.IsNullOrEmpty(strRead))
{
string[] aryVale = strRead.Split('\t');
DataRow dr = dt.NewRow();
for (int k = 0; k < aryVale.Length; k++)
{
dr[FieldsInArray[k]] = aryVale[k];
}
dt.Rows.Add(dr);
}
else
{
flag = false;
}
}
ds.Tables.Add(dt);
return ds;
}
文本文件转换成Dataset
最新推荐文章于 2021-08-29 19:40:07 发布