//DataSet dataSet = new DataSet();
            DataTable dt = new DataTable();
            //string connectString = string.Format(
            //    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=dBASE IV;User ID=Admin;Password=;", path);
            string connectString = string.Format(
             "Provider=VFPOLEDB.1;Data Source={0};Collating Sequence=MACHINE", path);
            using (OleDbConnection connection = new OleDbConnection(connectString))
            {
                
                try
                {
                    connection.Open();
                 
                    OleDbDataAdapter adapt = new OleDbDataAdapter();
                    adapt.MissingSchemaAction = MissingSchemaAction.AddWithKey;
                    adapt.SelectCommand = new OleDbCommand(sql, connection);
                    adapt.Fill(dt);
                    adapt.Dispose();
                    DataView dv = dt.DefaultView;
                    dv.Dispose();
                    connection.Close();
                    //connection.Open();
                    //OleDbDataAdapter command = new OleDbDataAdapter(sql, connection);
                    //if (command != null)
                    //{
                    //    command.Fill(dataSet);
                    //}
                }
                catch (Exception ex)
                {
                    MessageBox.Show(string.Format("error:{0}", ex.Message));
                    return null;
                }
               // return dataSet;
                return dt;

小弟电话：17717606525 感激不尽