Mike - Thank you for the link. Looks fairly straight forward but I  cannot quite figure out the correct vb 2010/10.3 Win form syntax for the following:

 UltraGridBand rootBand = this.citiesDropDown.DisplayLayout.Bands[0];   

        rootBand.ColumnFilters.ClearAllFilters();   

        rootBand.ColumnFilters["StateID"].FilterConditions.Add

if you could point me in the right direction i would appreciate it(if this was a really stupid question, I apologize in advance :)

Thanks

The second two lines you listed here are almost exactly the same in VB. The only different is that you have to use parentheses instead of square brackets. And, of course, there are no semicolons at the end of each line in VB. The first line is a variable declaration in C#, so you just have to use a Dim statement in VB.

This is just from memory, so it may not be exactly right, but something like this:

Dim rootBand as UltraGridBand = this.citiesDropDown.DisplayLayout.Bands(0)

rootBand.ColumnFilters.ClearAllFilters()

rootBand.ColumnFilters("StateID").FilterConditions.Add(...)

Thank you for your help. it is working great now.

hi All, sorry to resurrect an old post but i'm having a problem with that example. (http://news.infragistics.com/winforms/codesamples/creating-a-dropdown-list-in-a-grid-cell-whose-list-values-are-dependent-on-another-cell.aspx)

i have a portfolio dropdown, when changed, should filter the strategydropdown.

portfolio_dropdown.ValueMember = "PORTFOLIO_CODE";

portfolio_dropdown.DisplayMember = "PORTFOLIO_CODE";

strategy_dropdown.ValueMember = "TRADING_STRATEGY";//this is the actual value_member and want to keep it that way. this dropdown is bound to a table that does have "PORTFOLIO_CODE" to match portfolio dropdown.

strategy_dropdown.DisplayMember = "TRADING_STRATEGY";

this line, in my example, is throwing a "key not found" exception when i use my tables.

  rootBand.ColumnFilters["TRADING_STRATEGY"].FilterConditions.Add(FilterComparisionOperator.Equals, e.Cell.Row.Cells["PORTFOLIO_CODE"].Value); 

Mike, are you out there somewhere? what am i missing?

thanks everyone

Hi,

Yes, I'm here. :)

Key Not Found indicates that you are trying to access an item in a collection by key and there is no such item in the collection with that key.

So for this line of code, either there is no "TRADING_STRATEGY" column in the rootBand, or else there is no "PORTFOLIO_CODE" column in the band referred to by e.Cell.

Assuming that your column names are spelled correctly, perhaps this line of code is being hit before the DataSource has been bound to the control and so there are no columns at all?

Another possibility is that rootBand or e.Cell doesn't refer to what you think it does.

Hey Mike! thanks for responding. well, the grid is loaded by this time. i see the dropdowns and am able to select a value in PORTFOLIO_CODE. It's the rootBand.ColumnFilters["TRADING_STRATEGY"] line. i don't have a "TRADING_STRATEGY" column filter. no idea what even is.

i'm saying grid_AfterCellUpdate...

if columnkey=PORTFOLIO_CODE

{

the only columns i see in rootBand.ColumnFilters are all fields from table A (which is the PORTFOLIO, i'm not trying to filter that.) i'm trying to filter table B.PORTFOLIO_CODE.

}

table A( bound to portfolio_dropdown)

PORTFOLIO, PORTFOLIO_CODE

table B( bound to strategy_dropdown)

PORFOLIO_CODE, TRADING_STRATEGY

am i totally off the mark here?

Yeah that makes sense.

thanks Mike

Hi Al,

The combo doesn't have any built-in functionality to remove duplicates from the list. You would have to do that on the data source, or else filter out the duplicates yourself, which probably wouldn't be very efficient.

thanks Mike. that did work. i will mark as accepted answer.

But i have another question regarding the rows in _cbbrok. is there way to display only unique values?

i've bound it do a datasource that is distinct by another field in the datatable. i'm binding this cbo to the same data but displaying a different field. (one that happens to be repeating). can i just show distinct?

lmk if i'm not making sense.

thanks

Al

You could simplify this a little, by using

foreach (var row in _cbbrok.Rows.GetFilteredInNonGroupByRows())

This will loop through only the visible rows, so you do not need the IsFilteredOutCheck. This would also account for rows that you hid explicitly by setting the Hidden property, in addition to those rows that are filtered out.

found a solution..loop. :/

  private void gridData_AfterCellUpdate(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "PORTFOLIO")
            {
                UltraGridBand brokerBandToFilter = this._cbbrok.DisplayLayout.Bands[0];
              
                brokerBandToFilter.ColumnFilters.ClearAllFilters();
                brokerBandToFilter.ColumnFilters["TRADE_TYPE"].FilterConditions.Add(FilterComparisionOperator.Equals, e.Cell.Row.Cells["TRADE_TYPE"].Value);
                brokerBandToFilter.ColumnFilters["PORTFOLIO"].FilterConditions.Add(FilterComparisionOperator.Equals, e.Cell.Row.Cells["PORTFOLIO"].Value);
                if (_cbbrok.Rows.VisibleRowCount > 0) //<=====
                {
                    foreach (var row in _cbbrok.Rows) //<=====
                    {
                        if (!row.IsFilteredOut) //<=====
                        {
                            e.Cell.Row.Cells["CLEARING_BROKER"].Value = row.Cells["COUNTERPARTY_ID"].Value; //<=====
                            break;
                        }
                    }
                 
                }
            }
        }