private DataTable getDataTable(string sql)
{
switch (DB)
{
case DBType.Access:
Access access = new Access(connstr, Tout);
return(access.getDataTable(sql));
case DBType.MYSQL:
DataDriver.MySql mysql = new DataDriver.MySql(connstr, Tout);
return(mysql.getDataTable(sql));
case DBType.MSSQL:
DataDriver.MSSql mssql = new DataDriver.MSSql(connstr, Tout);
return(mssql.getDataTable(sql));
case DBType.SQLite:
DataDriver.SQLite sqlite = new DataDriver.SQLite(connstr, Tout);
return(sqlite.getDataTable(sql));
case DBType.PostgreSQL:
DataDriver.PostgreSQL pgsql = new DataDriver.PostgreSQL(connstr, Tout);
return(pgsql.getDataTable(sql));
default:
return(null);
}
}
private IDataBase MakeConnection()
{
IDataBase DBOper = null;
switch (DB)
{
case DBType.Access:
DBOper = new Access(connstr, Tout);
break;
case DBType.MYSQL:
DBOper = new DataDriver.MySql(connstr, Tout);
break;
case DBType.MSSQL:
DBOper = new DataDriver.MSSql(connstr, Tout);
break;
case DBType.Oracle:
DBOper = new DataDriver.Oracle(connstr, Tout);
break;
case DBType.SQLite:
DBOper = new DataDriver.SQLite(connstr, Tout);
break;
case DBType.PostgreSQL:
DBOper = new DataDriver.PostgreSQL(connstr, Tout);
break;
default:
DBOper = null;
break;
}
return(DBOper);
}
