string cnx

string selectQuery = "SELECT * FROM [MyLongF~1#DBF];";
OleDbCommand command = new OleDbCommand(selectQuery, connection);
connection.Open();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = command;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);

string cxn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:;Extended Properties=dBASE 5.0";
OleDbConnection connection = new OleDbConnection(cxn);

string cxn = "PROVIDER=VFPOLEDB.1;Data Source=C:;Extended Properties=dBASE 5.0";