Hello Tony,

From the code snippet you provided it seems that mDSetPackageDetails is a DataSet. Is this correct? If so, then the filter you are adding at this line:

rootBand.ColumnFilters["X_SUPRA_DSCNT_ID"].FilterConditions.Add(FilterComparisionOperator.Equals, mDSetPackageDetails);

should hide all the rows in the grid, as it is comparing the values in the cells against a DataSet, and I suppose the result is always false. As a first step try to comment out this row and check if the rows are gone again. If the rows are there try to fix your filter.

Please let me know if you have any additional questions on this matter.

There are several ways to show different drop down in a grid cell based on the value of the other cell in the same row. What we did in “Creating a dropdown list in a grid cell whose list values are dependent on another cell” was next:

• In InitializeLayout event we added two UltraDropDown controls to the form. statesDropDown was bound to a table containing information about all the states and citiesDropDown was bound to a table containing information about all the cities in US. The first UltraDropDown was set as ValueList to State column and second one to the City column. At this point if you run the application you will have all the cities shown in the City column’s cells;
• In BeforeCellActivate event we were checking if the cell to activate is in City column. If so we were getting the root band of citiesDropDown – this is the UltraDropDown we had added, not the band of the UltraGrid. Then we were clearing the filters and added a new one depending on the value of the cell under the State column in same row;

Form the code you send me it seems that you are using ValueList and not UltraDropDown. In this case you should either create a separate ValueList for each cell, or populate the ValueListItems every time the cell activates. There is no way to filter the items in ValueList. Attached is a small sample showing how to populate items in ValueList each time cell activates.

Please check my sample and let me know if this is what you are looking for or if I am missing something.

To answer your additional question – yes, you can examine the content of the value list. One way to achieve this is to put a break point in your code on the next row where ValueList items are populated. Then perform a QuickWatch over the ValueList or add it to the Watch window and investigate its content. Other possible way is to use System.Diagnostics.Debug.WriteLine method and to write the content of the ValueList in the Output window like this:

foreach (var item in valLstPackage.ValueListItems)    
{
    System.Diagnostics.Debug.WriteLine(
        "Item DataValue {0} Item DisplayText {1}",
        item.DataValue,
        item.DisplayText);
}

Please let me know if any additional questions on this matter arise.