Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 691
  • Last Modified:

How can I get the datasource to refresh itself - asp: sqldatasource wizard

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)">
                                        <SelectParameters>
                                            <asp:ControlParameter ControlID="DDLPlants" Name="plantid" 
                                                PropertyName="SelectedValue" Type="String" />
                                        </SelectParameters>
                                    </asp:SqlDataSource>

Open in new window

0
Bran-Damage
Asked:
Bran-Damage
  • 4
  • 3
1 Solution
 
ajb2222Commented:
is the first dropdown's autopostback property set to true?
0
 
Bran-DamageAuthor Commented:
No, I do not have the first one set to true, the second one is however.
0
 
ajb2222Commented:
try using Text instead of SelectedValue for PropertyName
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Bran-DamageAuthor Commented:
That did not work.  I'm going to try an explain this a little more in depth.

when the page loads, I have a drop down box that gets populated with location IDs.  Then another drop down box, (this one has the sqldatasource attached with the where clause being the locationid drop down box selectedvalue).  The location Id drop down box gets set to a default location, and everything I do on the screen populates correctly, even the sqldatasource drop down list.  Now, when someone changes the locationid drop down, there is a post back that happens, but the sqldatasource drop down list has old data in it from the previous locationid and no new data with the new selected location id.

0
 
ajb2222Commented:
Here is an example similar to what you are looking for.  It uses a drop down, gridview and 2 sqldatasource controls.  

http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewDropDownList.src&file=GridViewDropDownList_cs.aspx&lang=C%23+Source

0
 
Bran-DamageAuthor Commented:
I have gone another route with this.  None of these solutions worked for what I am trying to deal with.

Thanks.
0
 
Bran-DamageAuthor Commented:
Went another route.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now