I cannot find an adequate example of what I am trying to do. I'd appreciate any help or references to solve this problem:
I have a RadGrid with a custom edit form. In the form I would like to have two RadComboBoxes, say rcbState and rcbCity. I would like the rcbCity to automatically refresh its contents if rcbState changes. Again, I need to do this within the RadGrid FormTemplate.
I am using SQL Datasources:
<asp:SqlDataSource ID="sdsStates" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [states] order by state_name"></asp:SqlDataSource>
I don't know what to do for the second "city" datasource.
I am currently using DropDownLists:
<asp:DropDownList ID="ddlStateID" runat="server" SelectedValue='<%# Bind("state_id") %>' AppendDataBoundItems="True" DataSourceID="sdsStates" DataTextField="state_name" CssClass="select" DataValueField="state_id">
<asp:ListItem Selected="True" Text="Select" Value=""></asp:ListItem>
... mostly because I can't find an equivalent easy method of binding for the RadComboBox.
Any help is greatly appreciated!