Ok the queen of problems has another one for today. I am trying to create a very simple search, that will allow the user to enter in a record ID and bring up the FirstName and LastName from a Sql Server table. I have 3 text boxes txtSearch, txtFirstName, and txtLastName. The user should be able to enter in the record ID in txtSearch and display FirstName in txtFirstName and LastName in txtLastName. Very simple right? Well, I was able to get it working searching with firstname or lastname, but I can't get it to work when searching by ID. I'm going to paste my code below, if anyone could give me any tips it would make me very happy. If any further info is needed, just let me know.
First off, here is my web service where I create a dataset and connection to the database:
<WebMethod()> _
Go to the complete details ...