How can I refresh the data displayed in a ListView ASP.net 3.5 VS2008

I have a web form that uses a dataset to load the contents of a dataview based on the values selected from a couple of dropdown lists. It is possible that the data is updated by a page further in the application, but if an update has taken place the data is not refreshed on the web page. Is ther any way to force a Listview control to reload the data as databind() seems to have no effect.
Can you help?
TrilobyteMKRAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

samtran0331Commented:
>>the data is updated by a page further in the application

So when that page updates the data, how do you return to the page with the ListView?
Are you storing that dataset in session?
0
TrilobyteMKRAuthor Commented:
This is the code that builds the Listview, after the data is updated in a lter page I use a response.redirect to get me back to this page.
I'm new to asp.net 3.5 so any help would be appreciated.

Malcolm

 <asp:SqlDataSource ID="SqlDataSource3" runat="server"
    DataSourceMode="DataSet"
        EnableCaching="true"
        FilterExpression="IDMID = '{0}' and status ='{1}'"
        ConnectionString="<%$ ConnectionStrings:ConsumerProjectsConnectionString %>" SelectCommand="SELECT dbo.tbl_status.ConsID, dbo.Tbl_Status.Status, dbo.Tbl_Status.IDMID, dbo.Tbl_Consumer.EnqDate, dbo.Tbl_Consumer.Sal, dbo.Tbl_Consumer.Fname, dbo.Tbl_Consumer.Surname, dbo.Tbl_Consumer.Street, dbo.Tbl_Consumer.Town, dbo.Tbl_Consumer.Postcode, dbo.Tbl_Consumer.ConsNotes
FROM dbo.Tbl_Status INNER JOIN dbo.Tbl_Consumer ON dbo.Tbl_Status.ConsID = dbo.Tbl_Consumer.ConsID
ORDER By ConsID DESC;">
<FilterParameters>
<asp:ControlParameter
Name="IDM"
ControlID="Dropdownlist1"
PropertyName="Selectedvalue" />
<asp:ControlParameter
Name="Status"
ControlID="DropDownlist3"
PropertyName="SelectedValue" />
</FilterParameters>
</asp:SqlDataSource>
    <asp:ListView ID="ListView1" runat="server" DataKeyNames="ConsID"
        DataSourceID="SqlDataSource3">
        <ItemTemplate>
0
samtran0331Commented:
on the page with the listview, every datasource that has:
EnableCaching="true"

try either changing that to "false" or removing that attribute all together.

More info:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.enablecaching.aspx
"[When] data is cached, the Select method retrieves data from the cache rather than from the underlying database."
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TrilobyteMKRAuthor Commented:
Thank you, you're my hero!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.