{            
            System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection();
            //string table = @"D:\pro ceo\gkdata30.DBF";
            string table = textBox2.Text.Trim ();         
           if (table == "")
            {
                MessageBox.Show("请选择正确的数据库！");
                return;
            }
            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();
            try
            {               
                if (conn.State == ConnectionState.Open)
                {                    
                    MessageBox.Show ("连接成功！");                    
                }               
            }
            catch
            {
               MessageBox.Show("连接不成功！");
               return;
            }
            OdbcCommand cmd = new OdbcCommand("select * from " + table , conn);
            OdbcDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                MessageBox.Show("打开数据库成功！");
                return;
            }
            else
            {               
                MessageBox.Show("打开数据库不成功！");
                return;
            }      

}

如上代码，如果textbox2.text中数据库路径中有空格，红色代码这里就会提示“命令中有无法识别的短语或关键字”。
请问怎样能解决？

表格名两边加上[]试试

可以用一个数据库中函数去掉左右的空格可以用rtrim,ltrim
去掉空格就是了.

直接用正则表达式就可以了！

trim 去掉空格

replace(str," ","")

学习下

string table = textBox2.Text.Trim ();
==>
string table = "["+textBox2.Text.Trim ()+"]";