读书人

急c#操作dbf的有关问题

发布时间: 2012-01-14 20:02:35 作者: rapoo

急!!c#操作dbf的问题
我的代码
OdbcConnection conn = new OdbcConnection();
string table = @ "D:\3h-cms\4 Source Code\Code\数据200705.dbf ";
string connStr = @ "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB= " + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO ";

conn.ConnectionString = connStr;
conn.Open();


sql = "select * from "+table;
OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
当调试到da.Fill(ds)的时候就会跳出如下的错误
ERROR [42000] [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
有没有哪位大侠知道怎么解决啊,急!!

[解决办法]
up

读书人网 >C#

热点推荐