OBOUT - ASP.NET Super Form - Cascading ComboBox Field

Quick Links

ASP.NET Super Form - Cascading ComboBox Field

Order ID

11077

Ship Name

Ship Country

Ship City

Update

Cancel

...

Use the TemplateField class to gain full control over the layout of the field.
A TemplateField allows developers to specify different templates for view / add / edit modes.

This example showcases the use of two TemplateField objects - one for the "Ship Country" field and one for the "Ship City" field. Using the TemplateField class we can use ComboBox controls to edit the data from these fields. The two ComboBoxes are linked in cascade - when the selection changes in the "Ship Country" ComboBox, the "Ship City" ComboBox is populated with the cities located in the selected country.

For the source code please check the "aspnet_templates_combobox_cascading.aspx" sample from the SuperForm folder in the Suite.

ASP.NET

<obout:SuperForm ID="SuperForm1"
         runat="server"
         DataSourceID="SqlDataSource1"
         AutoGenerateRows="false">
        <Fields>
            <obout:TemplateField HeaderText="Ship Country">
                <ItemTemplate>
                    <%# Eval("ShipCountry") %>
                </ItemTemplate>
                <EditItemTemplate>
                    <obout:ComboBox  runat="server" ID="ComboBox1"  DataSourceID="SqlDataSource2" 
                     OnSelectedIndexChanged="ShipCountry_SelectedIndexChanged" AutoPostBack="true"
                     DataValueField="ShipCountry" DataTextField="ShipCountry" 
                    SelectedValue='<%# Eval("ShipCountry") %>'>
                </EditItemTemplate>
            </obout:TemplateField>
            <obout:TemplateField HeaderText="Ship City">
                <ItemTemplate>
                    <%# Eval("ShipCity") %>
                </ItemTemplate>
                <EditItemTemplate>
                    <obout:ComboBox  runat="server" ID="ComboBox1"  DataSourceID="SqlDataSource3" 
                     AppendDataBoundItems="false" >
                </EditItemTemplate>
            </obout:TemplateField>
        </Fields>
</obout:SuperForm>

protected void ShipCountry_SelectedIndexChanged(object sender, ComboBoxItemEventArgs e)
{
    SqlDataSource3.SelectParameters[0].DefaultValue = e.Item.Value;
}

Sub ShipCountry_SelectedIndexChanged(ByVal sender As Object, ByVal e As ComboBoxItemEventArgs)

    SqlDataSource3.SelectParameters(0).DefaultValue = e.Item.Value
    
End Sub

"You guys are the best! Thank you, you're making our lives much more easier."

Bronida Tarutin

Random testimonial All testimonials