This is a migrated thread and some comments may be shown as answers.

Binding the dropdown in grid by user defined function

5 Answers 115 Views

Grid

This is a migrated thread and some comments may be shown as answers.

5 Answers, 1 is accepted

answered on 02 Feb 2009, 05:40 AM

Hi Pushkar,

DataSourceID represents the ID(string ) of the DataSource control which will be used to populate the DropDown with data. You can set the DataSourceID for the GridDropDownColumn as shown below.

ASPX:

    
            <telerik:GridDropDownColumn    HeaderText="DropCol"  UniqueName="DropCol" DataSourceID="SqlDataSource1"  ListTextField="ProductName" ListValueField="ProductName"  DataField="ProductName"  ></telerik:GridDropDownColumn>

    
             <asp:SqlDataSource ID="SqlDataSource1" runat="server"   ConnectionString="<%$ ConnectionStrings:NorthWindConnectionString %>" 
        
                            SelectCommand="SELECT [ProductID], [ProductName], [SupplierID] FROM [Products]" > 
        
                        </asp:SqlDataSource>

Customize/Configure GridDropDownColumn

Shinu

answered on 03 Feb 2009, 06:56 PM

Pushkar - if I understand what you are wanting to do correctly, and functionality of grid, you could try setting something like the following in code behind:

    
            protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)  
        
                {  
        
                    if (e.Item is GridEditableItem && (e.Item as GridEditableItem).IsInEditMode)  
        
                    {  
        
                        GridEditableItem eeditedItem = e.Item as GridEditableItem;  
        
                        GridEditManager editMan = editedItem.EditManager;  
        
                        GridDropDownListColumnEditor editor = editMan.GetColumnEditor("PolicyType") as GridDropDownListColumnEditor;  
        
                        editor.DataSource = LoadPolicyType();  
        
                        editor.DataBind();  
        
                    }  
        
                }