Guest User

Untitled

a guest
Jan 11th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. private void button1_Click(object sender, EventArgs e)
  2. {
  3. SqlConnection objConnection = new SqlConnection(@"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=c:userss.l.msourcereposEmam Hossein UniversityEmam Hossein UniversityLoginDatabase.mdf;Integrated Security=True");
  4. string query = "Select *from Login where Username = '" + textBox1.Text.Trim() + "'and Password = '" + textBox2.Text.Trim() + "'";
  5. SqlDataAdapter objDataAdapter = new SqlDataAdapter(query, objConnection);
  6. DataTable dataTable = new DataTable();
  7. objDataAdapter.Fill(dataTable);
  8. string userString = textBox1.Text.ToString();
  9. string passString = textBox2.Text.ToString();
  10. if (dataTable.Rows.Count == 1)
  11. {
  12. UniversityMainPage objform = new UniversityMainPage();
  13. this.Hide();
  14. objform.Show();
  15.  
  16. }
  17. else
  18. {
  19. ErrorForm ef = new ErrorForm();
  20. ef.Show();
  21. }
  22. }
Add Comment
Please, Sign In to add comment