string excelname=wangyu;
string DBFtable = textBox2.Text.Trim();//dbf数据库
System.Data.Odbc.OdbcConnection DBFconn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + DBFtable + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO");
DBFconn.Open();
OdbcCommand DBFcmd = DBFconn .CreateCommand();
DBFcmd.CommandText="Selcet Xm From +DBFtable Where Xm=excelname";
OdbcDataReader DBFReader=DBFcmd .ExecuteReader ();
DBFReader .Read ()为什么没值呢?请大侠帮忙看一下!谢谢!
string DBFtable = textBox2.Text.Trim();//dbf数据库
System.Data.Odbc.OdbcConnection DBFconn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + DBFtable + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO");
DBFconn.Open();
OdbcCommand DBFcmd = DBFconn .CreateCommand();
DBFcmd.CommandText="Selcet Xm From +DBFtable Where Xm=excelname";
OdbcDataReader DBFReader=DBFcmd .ExecuteReader ();
DBFReader .Read ()为什么没值呢?请大侠帮忙看一下!谢谢!
Xm是字段,DBFtable是数据库文件,
这样的如何写才可以?
多谢!
应该把+DBFtable改为表名称
这样也不可以
string DBFtable = textBox2.Text.Trim();//路径下的dbf数据库
System.Data.Odbc.OdbcConnection DBFconn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + DBFtable + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO");
DBFconn.Open();
OdbcCommand DBFcmd = DBFconn .CreateCommand();
DBFcmd.CommandText="Select * From“ +DBFtable+ "Where Xm="+excelname;
OdbcDataReader DBFReader=DBFcmd .ExecuteReader ();
这样也不可以执行,什么原因呢?