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); } }