This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 11/29/2010 for the course MIS 333k taught by Professor Staff during the Fall '08 term at University of Texas at Austin.
- Fall '08