One textbox, Two Parameters, with Stored Procedure
I have a stored procedure that need two parameters, last name and first name. The first web page has a text box which the user can enter either the first name or last name; then the second page displays the return information. The application blows-up with an error message that states it: "Procedure 'usp_Name' expects parameter '@LName', which was not supplied."
How can I indicate that whatever is entered into the textbox is acceptable for the stored procedure to located the person by either last name or first name.