public void FillDatabaseLookupEdit()
{
if (serverLookUpEdit.EditValue != null)
{
string connectionString = CreateConnectionString();
ArrayList dataBases = null;
if (string.IsNullOrEmpty(connectionString))
{
return;
}
else
{
dataBases = DALUtils.GetDatabases(connectionString);
}
if (dataBases == null)
{
return;
}
dataBaseLookUpEdit.Properties.DataSource = dataBases;
dataBaseLookUpEdit.Properties.ShowHeader = false;
dataBaseLookUpEdit.Enabled = (dataBases.Count > 0);
testConnectionSimpleButton.Enabled = (dataBaseLookUpEdit.Enabled);
}
}
private void testConnectionSimpleButton_Click(System.Object sender, EventArgs e)
{
if (dataBaseLookUpEdit.EditValue == null)
{
MessageBox.Show("Select a database before testing the connection.", "Error Encountered", MessageBoxButtons.OK);
return;
}
bool success = DALUtils.TestConnection(CreateFullConnectionString());
if (success)
{
MessageBox.Show("Test Succeeded", "Test Connection", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Test Failed", "Test Connection", MessageBoxButtons.OK);
}
}
private void serversBackgroundWorker_DoWork(System.Object sender, System.ComponentModel.DoWorkEventArgs e)
{
m_Servers = DALUtils.GetSQLServers();
}