Advertisement
coasterka

LoginFormButtonClickEvent

Jan 14th, 2015
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.09 KB | None | 0 0
  1. // Login Form
  2. public void btnLoginLogin_Click(object sender, EventArgs e)
  3.         {
  4.             string connStr = @"Data Source=HRISI-PC;Initial Catalog=CourseWorkVP;Integrated Security=True";
  5.             SqlConnection sqlConn = new SqlConnection(connStr);
  6.  
  7.             string userName = txtBoxUsernameLogin.Text;
  8.             string password = txtBoxPassLogin.Text;
  9.  
  10.             sqlConn.Open();
  11.  
  12.             using (SqlCommand strQuery = new SqlCommand("SELECT * FROM Clients WHERE Name=@un AND Password=@pw", sqlConn))
  13.             {
  14.                 strQuery.Parameters.AddWithValue("@un", userName);
  15.                 strQuery.Parameters.AddWithValue("@pw", password);
  16.                 SqlDataReader sqldr = strQuery.ExecuteReader();
  17.                 if (sqldr.HasRows)
  18.                 {
  19.                     MessageBox.Show("Login Successful!");
  20.                     this.Close();
  21.                 }
  22.                 else
  23.                 {
  24.                     MessageBox.Show("Invalid Username / Password!");
  25.                     // lost password form?
  26.                 }
  27.             }
  28.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement