Hi! I have an excel data imported into a datatable and I appended an extra column in the datatable. I want to add a radiobutton list dynamically to specific cells in the appended column using a condition before I bind the whole table to DataGridView.
Eg: ID and Name from Excel sheet and Sex dynamically appended data column.
| ID | Name | Sex |
A01 Rob
B02 Mike
A03 Alex
B04 Steve
This how the data looks like in the Datatable through Data Visualiser.
I want to traverse through every datarow in the data table and assign a radiobuttonlist (Male, Female) in the Sex datacolumn cell where the ID cell of that row contains an 'A'. How do I achieve this dynamically?