I have an ASP.Net webpage (using VS 2008 to develop it) on the page is some textboes, dropdownlists etc. and a gridview. The gridview datasource is an accessdatasource so im using a access database.
Now when the user selects a row in the gridview the information from that row is populated into the textboxes and dropdownlists so that they can make any changes.
The problem im having is when they hit save changes and it updates the database i can't get the gridview to refresh instantly, i have to either refresh the page manually, or go to a different page on the gridview and then back to it.
I have tried using the DataBind() method of the gridview and also tried Response.Redirect to the same page but neither worked.
Any help is much appreciated, thanks in advanced.