How to set GridDropDownColumn DataSourceID to a dataset

[Ida]

Hi,

I have a dropdown list:

<telerik:GridDropDownColumn DataField="GroundGear" DataSourceID="getGroundGears" HeaderText="Ground Gear" ListTextField="GroundGearName" ListValueField="GroundGearCode" UniqueName="GroundGear" ColumnEditorID="GroundGear" Reorderable="False" Visible="false"></telerik:GridDropDownColumn>

With the datasource of "getGroundGears", embedded in the .aspx page:

 

<

 

 

asp:SqlDataSource ID="getGroundGears" runat="server"

 

 

 

ConnectionString="<%$ ConnectionStrings:FisheriesConnectionString %>"

 

 

 

SelectCommand="SELECT [Name] AS GroundGearName, [Code] AS GroundGearCode FROM [vwDisGroundGearAll] ORDER BY [DisplayOrder]">

 

 

 

 

 

 

 

</asp:SqlDataSource>

 

Though I would like the datasource for the dropdown to point to the method DisGroundGearAllTableAdapter.GetDisGroundGearAll.

How can I get the datasource to point to my tableadapters?

Thanks, Ida

[Konstantin Dikov]

Hello Ida,

You could easily achieve this when handling the server-side ItemDataBound event of the grid, get reference to the DropDownColumn edit control and assign the DataSet as DataSource of the RadComboBox. Here is an example:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridEditFormItem && e.Item.IsInEditMode)
    {
        GridEditFormItem item = e.Item as GridEditFormItem;
        RadComboBox comboBox = item["GroundGear"].Controls[0] as RadComboBox;
        comboBox.DataSource = GetDisGroundGearAll();
        comboBox.DataTextField = "GroundGearName";
        comboBox.DataValueField = "GroundGearCode";
        comboBox.DataBind();
    }
}

Additional information is available at the following help articles:

• RadComboBox - Binding to DataTable, DataSet, or DataView
• Customize/Configure GridDropDownColumn

Hope that helps.

 

Regards,
Konstantin Dikov
Telerik