Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. //open conn
  2. SqlConnection myConnection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\dbUser.mdf;Integrated Security=True");
  3. myConnection.Open();
  4.  
  5. //command Sql ดึงเฉพาะที่ใช้
  6. //SELECT * FROM tbUser WHERE Username= 'PhetAdmin' and Password='456789'
  7. SqlCommand myCommand = new SqlCommand("SELECT * FROM tbUser WHERE Username= 'PhetAdmin' and Password='456789", myConnection);
  8. SqlDataReader myDatareader = myCommand.ExecuteReader();
  9. //3
  10. myDatareader.Read();
  11. //close conn
  12. myConnection.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement