Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Project_Manager.Properties.Settings.Project_ManagerConnectionString"].ConnectionString);
- private void btnOK_Click(object sender, EventArgs e)
- {
- string user;
- user = txtUser.Text;
- string pass;
- pass = txtPass.Text;
- try
- {
- SqlCommand check = new SqlCommand("SELECT Username, Password FROM tblUsers WHERE Username = @user AND Password = @pass", con);
- check.Parameters.AddWithValue("@user", user);
- check.Parameters.AddWithValue("@pass", pass);
- con.Open();
- SqlDataReader reader = check.ExecuteReader();
- if (reader.HasRows)
- {
- Form.ActiveForm.Controls["menuStrip1"].Enabled = true;
- this.Close();
- // MessageBox.Show("Logged in as " + user, "Wellcome", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- else
- {
- con.Close();
- MessageBox.Show("Wrong username or password ", "Error Login Details", MessageBoxButtons.OK, MessageBoxIcon.Error);
- txtPass.Clear();
- txtUser.Clear();
- txtUser.Focus();
- }
- }
- catch (Exception ex)
- {
- MessageBox.Show("GREEEEEEESKAAAAAAAAAAA" + ex.ToString());
- }
- finally
- {
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement