I am using infragistics win grid. I am binding 3 columns in grid 1.Type 2.Status 3.Reason
There are 2 types as 1. Medication 2. Immunization .Status of each are as
Medication - > 1.Active 2.Inactive 3. Discontinued 4. Erroneous
Immunization - >1.Active 2.Inactive
On selection of first field of type in first dropdown second dropdown values are bind with respective field.
There are no. of rows in grid. Now on form load or on adding new row ;if last row of grid is for Immunization then only status for Immunization rows and Medication’s -> 1.Active 2. Inactive are displayed as text and for other status (3. Discontinued 4. Erroneous) of medication it shows id.
I am using grid.DisplayLayout.ValueLists.Add(status) for displaying text instead of Ids.
Please suggest me proper solution for this.
Thanks in advance.
It seems to me that you need 2 ValueLists and you need to set the ValueList of each cell in the Status column to the approriate list based on the Type.I recommend that you use the InitializeRow event for this.
Do not set the ValueList on the Column, because this will affect all of the cells in that column.