// 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 = "";
}
