// button: Connect
private void button1_Click(object sender, EventArgs e)
{
//проверка заполненых полей с именем входа
if (label4.Visible)
{
label4.Visible = false;
}
if (!checkBox1.Checked &&
(String.IsNullOrEmpty(textBox2.Text) || String.IsNullOrWhiteSpace(textBox2.Text) ||
String.IsNullOrEmpty(textBox3.Text) || String.IsNullOrWhiteSpace(textBox3.Text)))
{
label4.Visible = true;
label4.Text = "Fill the fields 'Login' and 'Password' or use 'Trusted connection'";
}
else
{
obj_sqlConnection = new mssqlConnection(textBox1.Text, textBox4.Text, textBox2.Text, textBox3.Text, checkBox1.Checked);
obj_sqlConnection.openConnection();
if (obj_sqlConnection.sqlConnection.State == ConnectionState.Open)
{
Form1.serverName = textBox1.Text;
Form1.databaseName = textBox4.Text;
Form1.loginName = textBox2.Text;
Form1.loginPassword = textBox3.Text;
Form1.loginTrusted = checkBox1.Checked;
Close();
}
}
}
// menu: Подключение
private void подключениеToolStripMenuItem_Click(object sender, EventArgs e)
{
loginForm.ShowDialog();
form1_mssqlConnection = new mssqlConnection(serverName, databaseName, loginName, loginPassword, loginTrusted);
form1_mssqlConnection.openConnection();
loadData();
}
// menu: Обновить
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (form1_mssqlConnection == null)
{
loginForm.ShowDialog();
form1_mssqlConnection = new mssqlConnection(serverName, databaseName, loginName, loginPassword, loginTrusted);
}
if (form1_mssqlConnection.sqlConnection.State != ConnectionState.Open)
{
form1_mssqlConnection.openConnection();
}
loadData();
}
