Hi, Mike...
If you're accessing VFP8 tables, I think you'll want to get the OLE DB Provider for VFP8. I don't know the specific URL, but you should be able to find it on Microsoft's web site.
You'll want to specify the Ole DB namespace at the top of your data access class...
using System.Data.OleDb;
And then when you want to do a query, you can do something like...
string cSQLString = "SELECT * FROM OneOfMyTables";
OleDbConnection oConn = new OleDbConnection("Provider=VFPOLEDB.1;" +
"Data Source=c:\\myappfolder\\data ");
DataSet DsReturn = new DataSet();
oConn.Open();
OleDbDataAdapter oAdapter = new OleDbDataAdapter(cSQLString, oConn);
oAdapter.Fill( DsReturn,"MyData");
(That's just a basic example, you'll probably want to wrap that up in a class/generic method)
Note that if you're using a container, in your data source I believe you'll want to specify that.
Finally, if you do a search on this forum for VFP and OLEDB, I believe you may find some previous questions and responses on this subject.
Hope this helps...
Kevin