Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void LogInTroughDB()
- {
- string serverName = "10.255.2.140\ADMIN\adminDB,1433";
- string userID = "admin";
- string password = "admin";
- SqlConnection cnn;
- string connetionString = null;
- connetionString = @"Server=" + serverName + ";Initial Catalog=master;User ID=" + userID + ";Password=" + password;
- cnn = new SqlConnection(connetionString);
- try
- {
- cnn.Open();
- //MessageBox.Show("Connection Open!");
- }
- catch (Exception ex)
- {
- MessageBox.Show("Connection Error!");
- }
- string sqlquery = ("SELECT * FROM dbo.Users WHERE (machine_name ='"+machine_name+"')"); ;
- SqlCommand command = new SqlCommand(sqlquery, cnn);
- SqlDataReader sReader;
- sReader = command.ExecuteReader();
- while(sReader.Read()) {
- first_name = sReader["first_name"].ToString();
- last_name = sReader["last_name"].ToString();
- userNameText.Text = first_name + " " + last_name;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement