DataSet mySet = null;
try
{
string strConn = @"Provider=vfpoledb;Data Source=" + path + ";Collating Sequence=machine;";
using (OleDbConnection myConnection = new OleDbConnection(strConn))
{
OleDbDataAdapter adpt = new OleDbDataAdapter("select * from " + OleDbName, myConnection);
mySet = new DataSet();
adpt.Fill(mySet);
myConnection.Close();
}
}