I am trying to use the asp: SqlDataSource wizard to populate my drop down list. My drop down list gets populated based upon what another drop down's selected value is. Now, during the page load, the drop down list gets populated correctly. But, when the user changes the selected value of the 2nd drop down, (which is what the first drop down list uses the selected value to bring back the records) the first drop down list does not populate new data. How can I get the databind to fire off automatically again on selected index change of the 2nd drop down list?
I have attached my sqldatasource code that is attached to my first drop down list.
<asp:SqlDataSource ID="sqlDSLTLCarrierList" runat="server"
ConnectionString="<%$ ConnectionStrings:ProcessShipperConnectionString %>"
SelectCommand="SELECT [cname] FROM [LTLCarriers] WHERE ([plantid] = @plantid)">
<asp:ControlParameter ControlID="DDLPlants" Name="plantid"
PropertyName="SelectedValue" Type="String" />