Hi, all...

I'm trying to do something in ASP.NET...here it is:

I have a reason code table with as few as 10 reason codes, or as many as a few hundred. Users need to be able to pick multiple reason codes as part of a filter selection for a report.

What I'd like to do is this...

SELECT Descript, 0 AS SELECTED FROM RsnCode...and put that into a recordset.

Then I want to drop an instance of a datagrid on a page, and bind the grid to the recordset, and set one of the columns as a checkbox...so that if the user checks 5 of the records in the grid, I can query the recordset after the fact to see which ones the user picked.

I know how to code the grid, but I'm not sure how to automatically bind the checkbox column in the grid to my recordset.

Has anyone tried to do this, or is there a better way?

(I realize I could try a multi-select list box, but a grid of checkboxes seems to be better from a UI perspective).

Thanks in advance,
Kevin