Thanks for the fast response. Your answer makes perfect sense.

So bear with me pls, if I understand you correctly I need to first make change to UltraGrid_InitializeLayout method by creating new instance of UltraCombo as shown below:

UltraGridColumn ugc = e.Layout.Bands[0].Columns[this.DataSet.DataTable.JOB_CLASS_IDColumn.ColumnName];            
UltraCombo uc = new UltraCombo();

BindingSource bs = new BindingSource(this.DataSet, this.DataSet.DataTable.TableName);

uc.BindingContext = this.BindingContext;            
uc.DisplayMember = this.DataSet.DataTable.NAMEColumn.ColumnName;            
uc.ValueMember = this.DataSet.DataTable.CLASS_IDColumn.ColumnName;            
uc.DataSource = bs;            
ugc.EditorComponent = uc;

This gives me the ultra combo rendered as expected.

Where I'm a little confused is how I filter the list when the Editor_BeforeEnterEditMode event method is called.

I cast my sender in the Editor_BeforeEnterEditMode method as UltraGridComboEditor, see below:

void Editor_BeforeEnterEditMode(object sender, CancelEventArgs e)        
{            
     UltraGridComboEditor combo = sender as UltraGridComboEditor;

However when I try to get to the combo valuelist to remove what I want, I cannot access it...what am I missing here?

So I have made some progress, based on your suggestion, I implemented UltraDropDown in my grid init layout method.

See below:

private void ultraGrid_InitializeLayout(object sender, InitializeLayoutEventArgs e)        
{            

UltraGridColumn ugc = e.Layout.Bands[0].Columns[this.DataSet.DataTable.CLASS_IDColumn.ColumnName];            
UltraDropDown uc = new UltraDropDown();

BindingSource bs = new BindingSource(this.DataSet, this.DataSet.DataTable.TableName);

uc.BindingContext = this.BindingContext;            
uc.DisplayMember = this.DataSet.DataTable.NAMEColumn.ColumnName;            
uc.ValueMember = this.DataSet.DataTable.LASS_IDColumn.ColumnName;            
uc.DataSource = bs;            
ugc.ValueList = uc;            
ugc.Editor.BeforeEnterEditMode += Editor_BeforeEnterEditMode;

return;

}

Then in my BeforeEnterEditMode method I access the DataSource and filter as needed. See below:

void Editor_BeforeEnterEditMode(object sender, CancelEventArgs e)        
{            

EditorWithCombo combo = sender as EditorWithCombo;            
UltraGridCell activeCell = this.ultraGrid.ActiveCell;            
UltraGridColumn ugc = this.ultraGrid.DisplayLayout.Bands[0].Columns[this.DataSet.DataTable.CLASS_IDColumn.ColumnName];

string currentClassId = this.ultraGrid.ActiveCell.Value.ToString();            
var vl = combo.ValueList as UltraDropDown;            
var bs = vl.DataSource as BindingSource;            
bs.Filter = "RETIRED_FLAG = 'N' AND CLASS_ID <> " + currentClassId;

vl.DisplayMember = this.DataSet.DataTable.NAMEColumn.ColumnName;            
vl.ValueMember = this.DataSet.DataTable.CLASS_IDColumn.ColumnName;            
vl.BindingContext = BindingContext;            
vl.DataSource = bs;            
ugc.ValueList = vl;                        
return;        

}

However, I'm still getting the same behavior as before where the new ValueList is translating DataValue to DisplayText.

I'm kinda at a loss on how to get this working, thanks for your help

Hi,

You are on the right track here, but you need to let the UltraDropDown do the filtering. Filtering the data source will end up with the same problem as before, because the editor will try to translate a DataValue to DisplayText and won't find the item on the list. So something like this:

void Editor_BeforeEnterEditMode(object sender, CancelEventArgs e)
        {
            this.ultraGrid = this.ultraGrid1;

            EditorWithCombo combo = sender as EditorWithCombo;
            UltraGridCell activeCell = this.ultraGrid.ActiveCell;

            string currentClassId = activeCell.Value.ToString();
            var vl = combo.ValueList as UltraDropDown;

            vl.DisplayLayout.Bands[0].ColumnFilters.ClearAllFilters();
            var columnFiltersRetiredFlag = vl.DisplayLayout.Bands[0].ColumnFilters["RETIRED_FLAG"];
            columnFiltersRetiredFlag.FilterConditions.Add(FilterComparisionOperator.Equals, 'N');
            var columnFiltersClassId = vl.DisplayLayout.Bands[0].ColumnFilters["Class_ID"];
            columnFiltersClassId.FilterConditions.Add(FilterComparisionOperator.NotEquals, currentClassId);
            
            return;

        }

Also... I would probably use the AfterCellActivate or AfterEnterEditMode event of the grid, rather then rely on an event on the editor.

Awesome now I see why you suggested to use the UltraCombo, I been stuck thinking I could use the binding source filter but that does not work for this requirement.

I implement your snippet and it worked great. I had to remove the last filter b/c I actually need to save the current ActiveCell contents off to the "side" so I can add that back into my list after I do the filter.

Why is that? Because if a user is clicks the dropdown for a retired class, but then changes their mind and wants to keep the retired class, I need to have that option still available in the dropdown.

 

Galahad Phillips said:

Why is that? Because if a user is clicks the dropdown for a retired class, but then changes their mind and wants to keep the retired class, I need to have that option still available in the dropdown.

Makes sense. Glad you got it all sorted out. :)

Estimated as I can do the following: in a form I have a ultracomboeditor I want when selecting a stored value process is executed and the result is loaded into a UltraGrid. Thanks in advance