Accessing and Updating Data in ASP.NET: Filtering Data Using a CheckBoxListWith a little bit of effort it is possible to filter data based on the end user's selections in a CheckBoxList control. This article starts with a look at how to get SQL to filter data based on a user-supplied, comma-delimited list of values. Next, it shows how to programmatically construct a comma-delimited list that represents the selected CheckBoxList values and pass that list into the SQL query. Finally, we'll explore creating a custom parameter control to handle this logic declaratively.
http://www.4guysfromrolla.com/articles/012010-1.aspx
Author