Solved

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

Posted on 2010-11-29
7
666 Views
Last Modified: 2012-05-10
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
Comment
Question by:Bran-Damage
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 6

Expert Comment

by:ajb2222
ID: 34234398
is the first dropdown's autopostback property set to true?
0
 

Author Comment

by:Bran-Damage
ID: 34234500
No, I do not have the first one set to true, the second one is however.
0
 
LVL 6

Expert Comment

by:ajb2222
ID: 34234743
try using Text instead of SelectedValue for PropertyName
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Bran-Damage
ID: 34239258
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
 
LVL 6

Expert Comment

by:ajb2222
ID: 34239483
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
 

Accepted Solution

by:
Bran-Damage earned 0 total points
ID: 34534765
I have gone another route with this.  None of these solutions worked for what I am trying to deal with.

Thanks.
0
 

Author Closing Comment

by:Bran-Damage
ID: 34618218
Went another route.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question