这是历史的记录
ASP.NET 直接导入CSV文件到DATASET
上一篇 /
下一篇 2008-04-14 16:35:23
/ 个人分类:工作心得
private void ImportCSVToDS()
{
int intColCount = 0;
bool blnFlag = true;
DataTable mydt = new DataTable("myTableName");
DataColumn mydc;
DataRow mydr;
string strpath = "D:\\ManifestItems20080409.txt";
string strline;
string [] aryline;
System.IO.StreamReader mysr = new System.IO.StreamReader(strpath);
while((strline = mysr.ReadLine()) != null)
{
aryline = strline.Split(',');
if (blnFlag)
{
blnFlag = false;
intColCount = aryline.Length;
for (int i = 0; i < aryline.Length; i++)
{
mydc = new DataColumn(aryline[i]);
mydc.ColumnName=i.ToString();
mydt.Columns.Add(mydc);
}
}
mydr = mydt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i];
}
mydt.Rows.Add(mydr);
}
dgData.DataSource =mydt;
dgData.DataBind();
}
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: