private void rbnBtnDBConnect_Click(object sender, EventArgs e)
{
try
{
if (rbnCboDBs.Text != "Select or Add Database")
{
if (DBC.IsConnected)
{
if (!DBC.Disconnect())
{
MessageBox.Show(
"Cannot disconnect current connection.\nPlease try again later !",
"Can not disconnect", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
else
{
rbnMain.StatusBar.Text = rbnMain.StatusBar.Text.Replace("connected", "disconnected");
}
}
DBC.ConnectionString =
new System.Data.SqlClient.SqlConnection(rbnCboDBs.Text.Trim('*'));
if (!DBC.Connect())
{
MessageBox.Show(
"Cannot connect to DB.\nPlease try again later !",
"Can not connect", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
else
{
rbnMain.StatusBar.Text = rbnMain.StatusBar.Text.Replace("disconnected", "connected");
}
}
else
{
MessageBox.Show(
"Please select a connection to connect to !",
"No connection specified", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(
ex.Message,
"Connecting to DB Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
