http://blog.sina.com.cn/s/blog_7acc74e50100w4hp.html
int intColCount = 0;
bool blnFlag = true;
DataTable mydt = new DataTable("myTableName");
DataColumn mydc;
DataRow mydr;
string strpath = "myTxt/RiChangRenWu.csv"; //cvs文件路径
string strline;
string [] aryline;
string fileFullName = System.Web.HttpContext.Current.Server.MapPath(strpath);
System.IO.StreamReader mysr = new System.IO.StreamReader(fileFullName, Encoding.GetEncoding("gbk"));
while((strline = mysr.ReadLine()) != null)
{
aryline = strline.Split(new char[]{','});
if (blnFlag)
{
blnFlag = false;
intColCount = aryline.Length;
for (int i = 0; i < aryline.Length; i++)
{
mydc = new DataColumn(aryline[i]);
mydt.Columns.Add(mydc);
}
}
mydr = mydt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i];
}
mydt.Rows.Add(mydr);
}
csv文件
ID,name,content,maerk
1,test1,test1,50
2,test2,test2,60