Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. string ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\matri\Desktop\test\DatabaseProject\DatabaseProject\database.mdf;Integrated Security = True";
  2.  
  3. using (SqlConnection con = new SqlConnection(ConnectionString))
  4. {
  5. con.Open();
  6. using (SqlCommand cmd = new SqlCommand("SELECT * FROM Users", con))
  7. {
  8. SqlDataReader reader = cmd.ExecuteReader();
  9. while (reader.Read())
  10. {
  11. MessageBox.Show("username = " + reader["username"].ToString() + " & password =" + reader["password"].ToString());
  12. }
  13. reader.Close();
  14.  
  15. cmd.ExecuteNonQuery();
  16. }
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement