private void initDB()
{
if (mssql != null)
{
mssql = null; //Think Better Way to Dispose
}
mssql = new MsSQL();
mssql.initMsSQL(DBHost, DBName, DBUserName, DBPassword);
mssql.connect();
}
// //////////////////////////////////////////////////////////////////////////////// //
//***************************** MsSQL Database Modules ************************************************//
private void initialiseDatabase()
{
try
{
readSettings();
if (mssql != null)
{
mssql = null; //TODO: Think How to Dispose
}
mssql = new MsSQL();
mssql.initMsSQL(DBHost, DBName, DBUName, DBPassword);
mssql.connect();
}
catch (Exception e)
{
MessageBox.Show(this, e.Message, "Exception@initDB", MessageBoxButtons.OK, MessageBoxIcon.Error);
Logger.log("Exception(initialiseDatabase):" + e.Message);
}
}
public void initialiseDatabase(string DBHost, string DBName, string DBUser, string DBPassword, string DP)
{
try
{
if (mssql != null)
{
mssql = null; //TODO: Think How to Dispose
}
mssql = new MsSQL();
mssql.initMsSQL(DBHost, DBName, DBUser, DBPassword);
mssql.connect();
DefaultPlant = DP;
LoadDBValues();
}
catch (Exception e)
{
MessageBox.Show(this, e.Message, "Exception@initDB", MessageBoxButtons.OK, MessageBoxIcon.Error);
Logger.log("Exception(MR:initialiseDatabase):" + e.Message);
}
}
