private void btnTest_Click(object sender, EventArgs e)
{
try
{
if (cbSqlServer.Text.Length > 0 || txtSqlPassword.Text.Length > 0 || txtSqlUsername.Text.Length > 0)
{
bool ConnectionStatus = false;
if (rbWindowsAuth.Checked == true)
{
SqlConnectionString = "Data Source=" + cbSqlServer.Text + ";Application Name=SRD;Integrated Security=SSPI" + txtSqlParameters.Text;
}
else
{
SqlConnectionString = "Data Source=" + cbSqlServer.Text + ";Application Name=SRD;User="******";Password="******"Connection Successful", "Connection Test", MessageBoxButtons.OK, MessageBoxIcon.Information); ConnectionStatus = true;
}
else
{
MessageBox.Show("Connection Unsuccessful", "Connection Test", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); ConnectionStatus = false;
}
if (ConnectionStatus == true)
{
btnSave.Enabled = true;
}
}
else
{
MessageBox.Show("One of the required fields are empty.", "New Connection", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
} catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// Confirms if the sql connection is valid
public static bool IsSqlCorrect(string sqlConnection)
{
return(MSSqlServer.CheckConnnection(sqlConnection));
}