Ok I have made a connection to a local database called userdatabase.
I have created a table in this database called Users.
The table called users has the following columns First Name, Last Name, UserID
I have created a couple of rows the first Bradley, West, 1120
The second Samantha, Winston, 1121.
Ok what I have on this form is three labels called FristNameLbl, LastNameLbl, UserIdLbl.
I also have a textbox called QueryTxt
I also have a button called SearchBtn
What I want to be able to do is enter a last name in the QueryTxt textbox and hit the search button.
If the last name exist in the table then the text for the FirstNameLbl should change to the First name of person, and so on for the other two labels I mentioned earlier. I have been searching for the answer for two days now and no one can seem to put it into simple terms that I can understand so If you answer and you are right I will choose your answer as best and provide you with five stars.
Thanks
Brad
I have created a table in this database called Users.
The table called users has the following columns First Name, Last Name, UserID
I have created a couple of rows the first Bradley, West, 1120
The second Samantha, Winston, 1121.
Ok what I have on this form is three labels called FristNameLbl, LastNameLbl, UserIdLbl.
I also have a textbox called QueryTxt
I also have a button called SearchBtn
What I want to be able to do is enter a last name in the QueryTxt textbox and hit the search button.
If the last name exist in the table then the text for the FirstNameLbl should change to the First name of person, and so on for the other two labels I mentioned earlier. I have been searching for the answer for two days now and no one can seem to put it into simple terms that I can understand so If you answer and you are right I will choose your answer as best and provide you with five stars.
Thanks
Brad