// Test the stored connection string public string TestSqlConnection() { PropertiesSettingsWorker PSWkr = new PropertiesSettingsWorker(); string strMsg = ""; // load sql connection string string connectionstring = PSWkr.G_SQLDatabaseConnectionString; try { // Attempt a connection SqlConnection connection = new SqlConnection(connectionstring); connection.Open(); strMsg = "SQL Connection: " + connection.State; connection.Close(); } catch (Exception err) { strMsg = err.Message.ToString(); } return strMsg; }
// constructor public lw_Bids_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// constructor public lw_ClientLocations_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// constructor public Application_Values_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// constructor public lw_ClientContact_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// based on SQL table name: lwdom_JobType // constructor public lwdom_JobType_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// based on SQL table name: lwdom_chemlist // constructor public lwdom_StateName_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// constructor public lw_InvoiceItems_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// based on SQL table name: lwdom_chemlist // constructor public lwdom_RatesID_Worker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }
// constructor public lwdom_chemlist_Woker() { PSWkr = new PropertiesSettingsWorker(); connectionString = ""; }