一个CSV格式文件如何导入到一个datatable中？

[LRAVPN]

一个CSV格式文件如何导入到一个datatable中？

[saucer]

1. parse the file yourself and create a DataRow for every row and add it to your DataTable

2. use OleDB's Excel driver to read it into a DataTable

[TheAres]

private void Form2_Load(object sender, System.EventArgs e)
{
string sConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=Text;" ;
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();

OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM test.csv", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;

DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1,"TEST");
daGrid1.DataSource = objDataset1.Tables[0].DefaultView;
objConn.Close();


}