c# vs2005 如何读取dbf文件，使用oledb方式

[lg7020]

c# vs2005 如何读取dbf文件，使用oledb方式

string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\教育培训\\Data;Extended Properties=dBASE IV;User ID=Admin;Password=";

OleDbConnection connection = new OleDbConnection(ConnectionString);


connection.Open();
string selectCommand = "select * from base.dbf";
// OleDbCommand myCommand = new OleDbCommand(selectString);
OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommand, connection);
DataSet customers = new DataSet();
adapter.Fill(customers, "base");
bindingSource1.DataSource = customers;


这样写报错！

[vengair]

string selectCommand = "select * from base.dbf";
from后面跟表名 不是 base.dbf 文件名
DataSource 那里跟文件名

[程序的色彩]

本人从事C#开发已有三年时间，希望结交行内好友，大家共同进取，
请加我的QQ群号码：35651007 注明CSDN即可

[cnjack]

可以用odbc直接調用呀;
用ODBC直接調用
string fileName=this.openFileDialog1.FileName;
string filePath=fileName.Substring(0,fileName.LastIndexOf("\\"));
string tableName=fileName.Substring(fileName.LastIndexOf("\\")+1);
tableName=tableName.Substring(0,tableName.LastIndexOf("."));
string connString="Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + filePath + ";Exclusive=No;";
DataTable dt=new DataTable("dayAttend");
OdbcConnection odbcConnection=new OdbcConnection(connString);
OdbcDataAdapter OdbcDataAdapter=new OdbcDataAdapter("select * from "+tableName,odbcConnection);
OdbcDataAdapter.Fill(dt);

[yuan731]

缺少connection.Close();
数据帮定不对
bindingSource1.DataSource = customers.DefaultView;