I have a dataset
Table Account and AccountType
I binded the grid to that dataset. In Accoun, it has a field AccountTypeId
Now the grid shows AccountTypeId. How can I not show the ID but the name of the account type ? Using the dataset
Yes. The easiest thing to do is set the Style property on the grid column to DropDownList or DropDownValidate.
Mike, the link you gave is very useful. I was able to bind the UltraDropDown and it works nicely. Is there a way to make value manually entered by the user to be constrained by the ValueList i.e. limited to the value that are in that DataTable?
Thanks!
This might help, also:
HOWTO:What is the best way to place a DropDown list in a grid cell?
One approach would be to use an UltraDropDown for the ValueList of the column and bind that UltraDropDown to the child table; you would set the DisplayMember to the column that you actually want to display and the ValueMember to the ID column. Another approach would be to hide the actual ID column and create an unbound column, copying over the mapped value to the unbound column in the InitializeRow event. The first approach should be pretty simple to implement, though.
-Matt