Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Login Form
- public void btnLoginLogin_Click(object sender, EventArgs e)
- {
- string connStr = @"Data Source=HRISI-PC;Initial Catalog=CourseWorkVP;Integrated Security=True";
- SqlConnection sqlConn = new SqlConnection(connStr);
- string userName = txtBoxUsernameLogin.Text;
- string password = txtBoxPassLogin.Text;
- sqlConn.Open();
- using (SqlCommand strQuery = new SqlCommand("SELECT * FROM Clients WHERE Name=@un AND Password=@pw", sqlConn))
- {
- strQuery.Parameters.AddWithValue("@un", userName);
- strQuery.Parameters.AddWithValue("@pw", password);
- SqlDataReader sqldr = strQuery.ExecuteReader();
- if (sqldr.HasRows)
- {
- MessageBox.Show("Login Successful!");
- this.Close();
- }
- else
- {
- MessageBox.Show("Invalid Username / Password!");
- // lost password form?
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement