ASP.net Forms/DropDownList Help
<p>I have created 2 dropdownlists that are binded to a SQL DB and then pulling up a GridView.  But, more specifically is there a way to have 3 user picked boxes and then have a Gridview show up?  I would like to have a quick efficient way to do this without problems.  I created the first 2 DDLs with autopostback and not working properly.  any suggestions?</p>

<pre><code>    &lt;asp:Label ID="CustomerNumberLabel" runat="server" Text="Customer Number " Width="125px"&gt;&lt;/asp:Label&gt;
    &lt;asp:DropDownList ID="CustomerNumber" runat="server" AutoPostBack="True" 
        DataSourceID="ADDRDataSource" DataTextField="SACSNO" 
        DataValueField="SACSNO" AppendDataBoundItems="True"&gt;
        &lt;asp:ListItem Text="Select a Customer" Value="" Selected="True" /&gt;
    &lt;/asp:DropDownList&gt;&lt;br /&gt;
    &lt;asp:SqlDataSource ID="ADDRDataSource" runat="server" 
        ConnectionString="&lt;%$ ConnectionStrings:iSeriesHistoryConnectionString %&gt;" 
        SelectCommand="SELECT [SACSNO] FROM [ADDR] WHERE ([SARP#1] = @column1)"&gt;
        &lt;SelectParameters&gt;
            &lt;asp:SessionParameter Name="column1" SessionField="userName" Type="Decimal" /&gt;
        &lt;/SelectParameters&gt;
    &lt;/asp:SqlDataSource&gt;
     &lt;asp:Label ID="ShipToNumberLabel" runat="server" Text="Ship-to Location " Width="125px"&gt;&lt;/asp:Label&gt;   
    &lt;asp:DropDownList ID="ShipToNumber" runat="server" 
        DataSourceID="ADDRShipToNumberDataSource" DataTextField="SASHNM" 
        DataValueField="SASHNM" AutoPostBack="True"&gt;
        &lt;asp:ListItem Text="Select Ship-To Location" Value="" Selected="True" /&gt;
    &lt;/asp:DropDownList&gt;
    &lt;asp:SqlDataSource ID="ADDRShipToNumberDataSource" runat="server" 
        ConnectionString="&lt;%$ ConnectionStrings:iSeriesHistoryConnectionString %&gt;" 
        SelectCommand="SELECT [SASHNM], [SASAD1], [SASAD2], [SASCTY], [SACSNO], [SASHST], [SASZIP] FROM [ADDR] WHERE ([SACSNO] = @SACSNO)"&gt;
        &lt;SelectParameters&gt;
            &lt;asp:ControlParameter ControlID="CustomerNumber" Name="SACSNO" 
                PropertyName="SelectedValue" Type="Decimal" /&gt;
        &lt;/SelectParameters&gt;
    &lt;/asp:SqlDataSource&gt;
   &lt;br /&gt;&lt;br /&gt;
    &lt;asp:FormView ID="FormView1" runat="server" 
        DataSourceID="ADDRShippingDataSource" Width="400px"&gt;
        &lt;EditItemTemplate&gt;
            SACSNO:
            &lt;asp:TextBox ID="SACSNOTextBox" runat="server" Text='&lt;%# Bind("SACSNO") %&gt;' /&gt;
            &lt;br /&gt;
            SASHNM:
            &lt;asp:TextBox ID="SASHNMTextBox" runat="server" Text='&lt;%# Bind("SASHNM") %&gt;' /&gt;
            &lt;br /&gt;
            SASAD1:
            &lt;asp:TextBox ID="SASAD1TextBox" runat="server" Text='&lt;%# Bind("SASAD1") %&gt;' /&gt;
            &lt;br /&gt;
            SASAD2:
            &lt;asp:TextBox ID="SASAD2TextBox" runat="server" Text='&lt;%# Bind("SASAD2") %&gt;' /&gt;
            &lt;br /&gt;
            SASCTY:
            &lt;asp:TextBox ID="SASCTYTextBox" runat="server" Text='&lt;%# Bind("SASCTY") %&gt;' /&gt;
            &lt;br /&gt;
            SASHST:
            &lt;asp:TextBox ID="SASHSTTextBox" runat="server" Text='&lt;%# Bind("SASHST") %&gt;' /&gt;
            &lt;br /&gt;
            SASZIP:
            &lt;asp:TextBox ID="SASZIPTextBox" runat="server" Text='&lt;%# Bind("SASZIP") %&gt;' /&gt;
            &lt;br /&gt;
            &lt;asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                CommandName="Update" Text="Update" /&gt;
            &amp;nbsp;&lt;asp:LinkButton ID="UpdateCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" /&gt;
        &lt;/EditItemTemplate&gt;
        &lt;InsertItemTemplate&gt;
            SACSNO:
            &lt;asp:TextBox ID="SACSNOTextBox" runat="server" Text='&lt;%# Bind("SACSNO") %&gt;' /&gt;
            &lt;br /&gt;
            SASHNM:
            &lt;asp:TextBox ID="SASHNMTextBox" runat="server" Text='&lt;%# Bind("SASHNM") %&gt;' /&gt;
            &lt;br /&gt;
            SASAD1:
            &lt;asp:TextBox ID="SASAD1TextBox" runat="server" Text='&lt;%# Bind("SASAD1") %&gt;' /&gt;
            &lt;br /&gt;
            SASAD2:
            &lt;asp:TextBox ID="SASAD2TextBox" runat="server" Text='&lt;%# Bind("SASAD2") %&gt;' /&gt;
            &lt;br /&gt;
            SASCTY:
            &lt;asp:TextBox ID="SASCTYTextBox" runat="server" Text='&lt;%# Bind("SASCTY") %&gt;' /&gt;
            &lt;br /&gt;
            SASHST:
            &lt;asp:TextBox ID="SASHSTTextBox" runat="server" Text='&lt;%# Bind("SASHST") %&gt;' /&gt;
            &lt;br /&gt;
            SASZIP:
            &lt;asp:TextBox ID="SASZIPTextBox" runat="server" Text='&lt;%# Bind("SASZIP") %&gt;' /&gt;
            &lt;br /&gt;
            &lt;asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                CommandName="Insert" Text="Insert" /&gt;
            &amp;nbsp;&lt;asp:LinkButton ID="InsertCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" /&gt;
        &lt;/InsertItemTemplate&gt;
        &lt;ItemTemplate&gt;
            Customer Detail&lt;br /&gt;
            &lt;br /&gt;
            &lt;table class="style1" width="35px"&gt;
                &lt;tr&gt;
                    &lt;td class="style2" align="center" &gt;
                        Address Line 1&lt;/td&gt;
                    &lt;td class="style3" align="center" &gt;
                        &lt;asp:Label ID="SASAD1Label" runat="server" Text='&lt;%# Bind("SASAD1") %&gt;' /&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;tr&gt;
                    &lt;td class="style2" align="center" &gt;
                        Address Line 2&lt;/td&gt;
                    &lt;td class="style3" align="center" &gt;
                        &lt;asp:Label ID="SASAD2Label" runat="server" Text='&lt;%# Bind("SASAD2") %&gt;' /&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;tr&gt;
                    &lt;td class="style2" align="center"&gt;
                        City&lt;/td&gt;
                    &lt;td class="style3" align="center" &gt;
                        &lt;asp:Label ID="SASCTYLabel" runat="server" Text='&lt;%# Bind("SASCTY") %&gt;' /&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;tr&gt;
                    &lt;td align="center" class="style2"&gt;
                        State&lt;/td&gt;
                    &lt;td class="style3" align="center" &gt;
                        &lt;asp:Label ID="SASHSTLabel" runat="server" Text='&lt;%# Bind("SASHST") %&gt;' /&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
                &lt;tr&gt;
                    &lt;td align="center" class="style2"&gt;
                        Zip&lt;/td&gt;
                    &lt;td class="style3" align="center" &gt;
                        &lt;asp:Label ID="SASZIPLabel" runat="server" Text='&lt;%# Bind("SASZIP") %&gt;' /&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
            &lt;/table&gt;
            &lt;br /&gt;
        &lt;/ItemTemplate&gt;
    &lt;/asp:FormView&gt;
    &lt;asp:SqlDataSource ID="ADDRShippingDataSource" runat="server" 
        ConnectionString="&lt;%$ ConnectionStrings:iSeriesHistoryConnectionString %&gt;" 
        SelectCommand="SELECT [SACSNO], [SASHNM], [SASAD1], [SASAD2], [SASCTY], [SASHST], [SASZIP] FROM [ADDR] WHERE ([SASHNM] = @SASHNM)"&gt;
        &lt;SelectParameters&gt;
            &lt;asp:ControlParameter ControlID="ShipToNumber" Name="SASHNM" 
                PropertyName="SelectedValue" Type="String" /&gt;
        &lt;/SelectParameters&gt;
    &lt;/asp:SqlDataSource&gt;
</code></pre>
