I have a design problem I could use some help determining how to code this problem.
I have a table with 3 fields, catCode, startDate and endDate. I am having trouble deciding how to query my DB based on the following...
By default a gridview will return all records that match the catCode selected from a dropdown list.
If the user checks a check box, only records are returned where....
startDate <= today AND endDate >= today
How can I apply the If condition to compare when the check box is selected? I used the wizard to build the select statment for the gridview, but I can switch that to a SP if that makes life easier.
Thanks for any and all help and suggestions.
View Complete Post