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

lucksea521 2011-12-05 04:24:22

                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);

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

                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.”

...全文