用odbc可以执行而oledb不能执行

C# code

                System.Data.Odbc.OdbcConnection DBFconn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + textBox2.Text.Trim() + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO");

                DBFconn.Open();
                OdbcCommand DBFcmd = DBFconn.CreateCommand();

                System.Data.Odbc.OdbcDataAdapter thisdbfdataadapter = new OdbcDataAdapter("select * from " + textBox2.Text.Trim(), DBFconn);
                OdbcCommandBuilder thisdbfbuilder = new OdbcCommandBuilder(thisdbfdataadapter);
                
                DataSet thisdbfdataset = new DataSet();

                System.Data.DataTable DBFdt = new System.Data.DataTable();


                thisdbfdataadapter.Fill(DBFdt);

上面这个可执行，下面这个不能执行，是什么原因？


C# code

                OleDbConnection DBFconn = new OleDbConnection(@"Provider=vfpoledb;Data Source=" + textBox1.Text .Trim () + ";Extended Properties=dBASW IV;User ID=;Password=");
                //DBFconn.Open();
                DBFconn.Open();
                OleDbCommand DBFcmd = DBFconn.CreateCommand();
                OleDbDataAdapter ThisDBFDataAdadapter=new OleDbDataAdapter ("select * from" +textBox1 .Text .Trim (),DBFconn );
                OleDbCommandBuilder ThisDBFBuilder=new OleDbCommandBuilder (ThisDBFDataAdadapter );

                DataSet ThisDBFDataSet=new DataSet ();
                System .Data .DataTable ThisDBFDT=new System.Data.DataTable ();
                
                
                ThisDBFDataAdadapter.Fill(ThisDBFDT);

ThisDBFDataAdadapter.Fill(ThisDBFDT);这提示“未处理OleDbException Command contains unrecognized phrase/keyword.”

帮你顶顶帖子吧

这是什么原因呢？