Build a web site with one web page. The page has a checkbox list control which shows the eight product categories from the categories table in the northwind database.
If a user presses the button without choosing any item from the checkbox list, the textbox beneath the checkbox list won’t show anything.
If a user selects at least one category and presses the button, the textbox will show SQL statement based on the user’s selection. For example, suppose the user selects “meat/poultry”, the category ID of which is 6, the textbox will output the following
SQL statement:
On the other hand, if “Seafood” is chosen, then the output in the textbox will be:
SELECT * FROM PRODUCTS WHERE categoryID=8
Because the category ID of “Seafood” is 8.
If a user chooses “Seafood” and “Meat/Poultry both, then the ...
Go to the complete details ...