Coding a CheckBoxList

[timothy2l]

I have a CheckBoxList with the following items:

 

-Last Name

-Major

-Start Year

-Graduation Year

 

There is a corresponding text box for each of the items. What i want to do is make it so that when a user checks one of the boxes and clicks submit, records will be returned to them depending on which check box they chose. For example.

 

'Last Name' is checked and "Johnson" is entered in the txtLastName

 

Submit is clicked and all records with LastName = Johnson are returned from the database. Right now LastName is the only one that works and when multiple boxes are checked, an empty datagrid is returned. What is the simplest way to code this so that multiple checkboxes can be checked to narrow down the records returned?

 

Thanks

[mutant]

What if the user chooses more than one? Its a checkbox list. Maybe you should use RadioButtons if you want to limit to only one.

[timothy2l]

What I had in mind was to let the user check multiple boxes. So if they checked Last Name and Major and entered Johnson and Accounting then all records containing those values would be returned. They could check all boxes if they wanted to. Is there an easy way to do this?