DetailTable in RadGrid problem

[fecteaum]

Hi,

I am using RadGrid with a MasterTableView (Orders table) with a DetailTables (OrderDetails Table). In my OrderDetails  i have 19 fields, just a few of them are visibles in the grid but they are all editables in the EditForm.

I have the customer field and the product field that are GridDropDownColumn. But ia have a problem because i have about 10000 customers and 20000 products.  It take a long time to load the page when I want to modify an item in the OrderDetail. Finaly after the page is load,  i have a warning "Stop the execution of this script? A script on this page slows Internet Explorer.
If it continues, your computer may stop responding.  Yes or No."

Is it possible to load on demand those two GridDropDownColumns or maybe is it possible to enter the 1st, 2 first or 3 first characters of the customer number or the product number before loading the corresponding table?

Or is is possible to use a RadComboBox in a FormTemplate.

Thanks

[Princy]

Hi,

You can set the DropDownControlType for the DropDownColumn to RadComboBox and then access the combobox in the code behind and set its LoadOnDemand property to true as shown below.
aspx:

 <telerik:GridDropDownColumn DataSourceID="SqlDataSource1" DropDownControlType="RadComboBox" UniqueName="Supplier" DataField="SupplierID">
 </telerik:GridDropDownColumn>

cs:

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem && e.Item.IsInEditMode)
        {
            GridDataItem dat = (GridDataItem)e.Item;
            RadComboBox rdcbx = (RadComboBox)dat["Supplier"].Controls[0];
            rdcbx.EnableLoadOnDemand = true;
        }
   }

Princy.