Distinct
 Next   Menu    Previous 
Docs

The Distinct property when set to true will only select distinct (unique) values. In this example the customers table is filtered by selecting customers for select distinct countries and cities.
Countries
Cities
Customers
Contact Name
Contact Title
Address
City
Region
Postal Code
Phone
Fax
Razor
                                
                                        
DbNetComboCore customerCombo = new DbNetComboCore("northwind", "customers", "companyname", null, "customer")
{
        ForeignKeyColumn = "city",
        Size = 5,
        AutoRowSelect = true,
        DataOnlyColumns = new List () { "ContactName", "ContactTitle", "Address", "City", "Region", "PostalCode", "Country", "Phone", "Fax" },
};
customerCombo.Bind(EventType.OnOptionSelected, "showSelectedCustomer");
DbNetComboCore cityCombo = new DbNetComboCore("northwind", "customers", "city", null, "city")
{
    ForeignKeyColumn = "country",
    Size = 5,
    Distinct = true,
    AutoRowSelect = true
};
DbNetComboCore countryCombo = new DbNetComboCore("northwind", "customers", "country", null, "country")
{
    Size = 10,
    Distinct = true,
    AutoRowSelect = true
};
cityCombo.AddLinkedControl(customerCombo);
countryCombo.AddLinkedControl(cityCombo);
@countryCombo.Render()