SqlDataSource not reselecting data from database when data is changed

Question

I have a Dropdown list being populated by an SqlDataSource, with the following markup:

Dropdown:

<asp:DropDownList ID="SaleIDDropDown" runat="server" CssClass="dropdown" 
    DataSourceID="DropDownDataSource" DataTextField="Title" DataValueField="ID"
    AppendDataBoundItems="true">
</asp:DropDownList>

DataSource

<asp:SqlDataSource ID="DropDownDataSource" runat="server" 
    ConnectionString="<%$ ConnectionStrings:SQL-DEV %>" 
    SelectCommand="SELECT [ID], [Title], [userid] FROM [AdSelect]">
</asp:SqlDataSource>

The problem I'm running into is when some of the data is changed via the web interface I'm making (I delete an item, or change it's Title for example) the Dropdown populates with the old data, even though it clearly has changed in the DataBase (I checked using SQL Server Studio). If I reload the page, then the Dropdown is finally populated correctly.

I need a way to "force" a refetching/selecting of the data, but my efforts have so far failed. I've tried doing it in code, but it's not taking effect.

DropDownDataSource.Select(DataSourceSelectArguments.Empty);
DropDownDataSource.DataBind();

SaleIDDropDown.DataBind();

It still doesn't update the dropdown, even when this is run.

How can I make the dropdown and its SqlDataSource and push it to the page on command?

TylerH · Accepted Answer · 2025-09-30 19:37:09Z

2

Please note that even though your solution with disabling viewstate works, it is far from optimal because it will load the data from database on every postback.

If it’s a busy website you don’t really want that. Try spending some more time on the SaleIDDropDown.DataBind(); command. That must refresh the data, but I guess you’re not doing this in correct place, or something like that...

edited Sep 30 at 19:37

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Aug 13, 2013 at 10:02

ScottS

4624 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

akowalz Over a year ago

Thank you. I thought I had solved the problem by disabling ViewState, but I was creating about 10 more problems in the process. The problem ended up being that my DataBind was in Page_Load, so it would bind the data and then do the event that deleted the item from the Dropdown. I needed to another DataBind in the event handler for the delete button.

Booji Boy · Accepted Answer · 2023-10-12 18:44:09Z

1

I've also found that if the SQLDataSource control has CancelSelectOnNullParameter="True" (the default) and any the Select Parameter has ConvertEmptyStringToNull="true" and the parameter is blank .. then query won't run. Sounds obvious but it's tripped me up.

answered Oct 12, 2023 at 18:44

Booji Boy

4,6024 gold badges42 silver badges45 bronze badges

Comments

TylerH · Accepted Answer · 2025-09-30 19:34:33Z

0

_{From a now-deleted answer by the question author:}

I fixed this by turning off viewstate for the SqlDataSource control, ie setting EnableViewState="False" in the SqlDataSource markup.

This fixed the problem, I guess the data was being updated by the old ViewState data was getting in the way. Try this out if you have the same problem.

answered Aug 12, 2013 at 19:11 by akowalz

answered Sep 30 at 19:34

community wiki

TylerH

Collectives™ on Stack Overflow

SqlDataSource not reselecting data from database when data is changed

Dropdown:

DataSource

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Dropdown:

DataSource

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related