public static void SelectLoginPass(string Login, string Password)
{
try
{
sqlConnection.Open();
sqlDataAdapter = new SqlDataAdapter("SELECT COUNT(*) FROM Users WHERE Login = '******' AND Password = '******'", sqlConnection);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
if (dataTable.Rows[0][0].ToString() == "1")
{
OpeningForms.OpenMainForm();
}
else
{
MessageBox.Show("No such user found!");
}
sqlConnection.Close();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlConnection.Close();
}
}
private void BtnClose_Click(object sender, EventArgs e)
{
this.Hide();
OpeningForms.OpenLoginForm();
}
private void BtnRegistration_Click(object sender, EventArgs e)
{
this.Hide();
OpeningForms.OpenRegistrationForm();
}
