Binding a radiobuttonlist to a filtered datatable?
Posted on 2006-03-29
I have a datatable that I would like to bind to a radiobuttonlist; however, I don't want all of the items to show up, so I filtered the datatable but this doesn't seem to make a difference when binding it to the radio list. Here is an example of my table:
ROLE_ID ROLE_NAME AREA
1 Greater Admin Admin
2 Admin Admin
3 Read Maintenance
4 Write Maintenance
5 Alter Maintenance
plus many more. In this case, I want only the role_names for the "maintenance" area, with the value being the role_id. Here is my code (roleOptions is my datatable):
RadioButtonList rdoList = new RadioButtonList();
rdoList.RepeatDirection = RepeatDirection.Horizontal;
rdoList.DataSource = roleOptions;
rdoList.DataValueField = "role_id";
rdoList.DataTextField = "role_name";
It doesn't limit it to just the maintenance roles. It shows:
*Greater Admin *Admin *Read *Write *Alter
when I want it just to show:
*Read *Write *Alter
I am unsure how to make this easy. I tried a hashtable and binding it and that worked awesome, but it put it in any order it wanted, which I couldn't do. Then I tried a SortedList, but you can't control how it sorts so I dumped that idea too. Then I tried the ArrayList, but I couldn't have different value and text fields with that. So now I'm trying the datatable. I can't limit the data to maintenance when I retrieve it because I will be using it for other things.
Thanks for the help.