private void DbSqlForm_Load(object sender, EventArgs e)
{
_db = new DBClassSQLite();
_db.OpenDB();
_initialConStr = null;
LoadInfoFromLocalDb();
}
public MainDBClass()
{
sqliteProvider = new DB_Class_SQLite.DBClassSQLite();
string conString = string.Empty;
int bUseSQlServer = 0;
DBClassSQLite db1 = new DBClassSQLite();
db1.OpenDB();
if (db1.isTableExist("tb_SqlServer_Info"))
{
db1.getSqlServerInfo(out conString, out bUseSQlServer);
}
db1.CloseDB();
if ((bUseSQlServer == 1) && (!string.IsNullOrEmpty(conString)))
{
useDb = dbUsedType.db_SqlServer;
sqlServerProvider = new DBClassSqlServer.DBSqlServer(DBClass_SQLServer.UtilSqlServer.ConvertConnectionString(conString));
try
{
OpenDB();
CloseDB();
}
catch
{
useDb = dbUsedType.db_SqlLite;
ErrorMessage.ExceptionMessageBox.Show("Unable to connect to SQL Server Database - Application start with local database to check configuration", "Information");
}
}
}
private void ExportFrm_Load(object sender, EventArgs e)
{
_db = new DBClassSQLite();
_db.OpenDB();
_initialConStr = null;
_tableName = null;
LoadInfoFromLocalDb();
}
