Unformatted text preview: order when one of the search buttons is pressed. Name the application ASP6 and the form Search.aspx. You can use the same employee login form from your previous homework, but you must use ONLY stored procedures for ALL database access. Follow all form and coding standards as usual. Partial search use the LIKE statement: SQL Hint: SELECT * FROM tblCustomers WHERE LastName LIKE ‘search_string_goes_in_here%’ The “%” on the end of what the user types will tell SQL, along with the LIKE statement will tell SQL to find all records where the last name starts with whatever is in the search textbox. Please show the number of records shown in the gridview at all times. When the form opens, the sort by name radio button should be selected and the records should be sorted. You may use dataviews on this assignment. Make sure to reload the table before grading....
View Full Document
- Fall '08
- Text box, Widgets, Stored Procedures