Use data in gridview to get another query

[richlp]

I have a gridview with a datasource.

I also have a CheckBoxList with a set of Status Codes and
a RadioOptionList with a set of Action Codes.

There is a button on the form to "Update Chart" When that is pressed I want to do something on the order of

SELECT * FROM (the gridview's datasource) WHERE status IN (the checked items.value) AND action = (radioOption.value)

and then put the results somewhere (presumably a dataset) which the chart can then reference.

Any help is muchly appreciated.........Rich

 

[Tom]

You can create a DataView of your datasource (DataSet/DataTable) and then filter it by your user selected items.