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(); }