Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. public void LogInTroughDB()
  2. {
  3.  
  4. string serverName = "10.255.2.140\ADMIN\adminDB,1433";
  5. string userID = "admin";
  6. string password = "admin";
  7. SqlConnection cnn;
  8. string connetionString = null;
  9. connetionString = @"Server=" + serverName + ";Initial Catalog=master;User ID=" + userID + ";Password=" + password;
  10. cnn = new SqlConnection(connetionString);
  11. try
  12. {
  13. cnn.Open();
  14. //MessageBox.Show("Connection Open!");
  15. }
  16. catch (Exception ex)
  17. {
  18. MessageBox.Show("Connection Error!");
  19. }
  20.  
  21.  
  22. string sqlquery = ("SELECT * FROM dbo.Users WHERE (machine_name ='"+machine_name+"')"); ;
  23. SqlCommand command = new SqlCommand(sqlquery, cnn);
  24. SqlDataReader sReader;
  25. sReader = command.ExecuteReader();
  26. while(sReader.Read()) {
  27. first_name = sReader["first_name"].ToString();
  28. last_name = sReader["last_name"].ToString();
  29. userNameText.Text = first_name + " " + last_name;
  30. }
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement