I have a table for a subscription list in Oracle with several columns where one is a NUMBER (0/1) since Oracle doesn't have a boolean type.
It might look something like this
| NAME | FLAG | DATESENT |
+-------+-------+----------+
| Feed1 | true | 07/22/09 |
+-------+-------+----------+
| Feed2 | false | 07/22/09 |
+-------+-------+----------+
I would like users to be able to edit all the rows at once in ASP.NET by generating a list of checkboxes, one for each row, and let the users be able to toggle as many as they wish and save them all.
The ASP.NET CheckBoxList seems to be a good solution, but it looks for boolean columns when it is databound. I also considered some kind of GridView, but I do not know how to make all rows be in edit mode at once. Usually it's one row at a time.
Is there a nice, .NETish way to perform this besides forcing my way through?