GridDropDownColumn question

[Richard]

I have two tables, customers and addresses.  Each customer may have many addresses, with one default address. Simplifed a bit they contain the following fields:

Customers table - Name, CustomerID, DefaultAddressID
Addresses table - Address, AddressID, CustomerID

I am using a RadGrid to edit customers, and I would like to add a function to select the default address using a GridDropDownColumn. Currently, this is listing all the addresses, not just the ones for that customer.

How can I restrict the dropdown box to only list addresses for that customer?

Kind Regards, Richard Jonas

[Tsvetina]

Hello Richard,

My advice is to use a GridTemplateColumn for this purpose. You can define an EditItemTemplate with a RadComboBox and populate it when the edit form for a specific record is bound:

<EditItemTemplate>
    <telerik:RadComboBox ID="RadComboBox1" runat="server">
    </telerik:RadComboBox>
</EditItemTemplate>

As you probably know the Northwind table has a similar relation between the Orders and Customers table - a single customer can have multiple orders. CustomerID is a column in both tables and here is how the requirement can be handled in this context:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        string key = (e.Item as GridEditableItem).GetDataKeyValue("CustomerID").ToString();
        RadComboBox combo = e.Item.FindControl("RadComboBox1") as RadComboBox;
        combo.DataSource = GetComboData("SELECT CustomerID, OrderID FROM [Orders] WHERE CustomerID='"+key+"'");
        combo.DataValueField = "OrderID";
        combo.DataTextField = "OrderID";
        combo.DataBind();
        combo.SelectedValue = key;
    }
}

I hope this helps.

Greetings,
Tsvetina
the Telerik team