public static System.Data.DataTable ExecuteDataTable(DbfFormat dbfFormat, string aDBQ, string aCommand)
{
System.Data.DataTable table = new System.Data.DataTable();
string odbcConnectionString = GetOdbcConnectionString(dbfFormat, aDBQ);
new System.Data.Odbc.OdbcDataAdapter(aCommand, odbcConnectionString).Fill(table);
return table;
}
public static string GetOdbcConnectionString(DbfFormat dbfFormat, string aDBQ)
{
if (dbfFormat == DbfFormat.dBaseIII)
{
return (Constants.GetODBCdBaseIIIConnectionString() + "DBQ=" + aDBQ + ";");
}
return DBF.ConnectionString.Replace("%DESTDIR%", aDBQ).Replace("%FORMAT%", "dBase III");
}
