I'm trying to update existing records, as 'in try it out' P270 and have run into a problem. When I Update an entry I have to close the connection to the browser and reopen it for the change to take effect on the page I'm working on.What am I doing wrong? Can anyone help, please? I found chapter 7 was a bitch,so many errors that aren't covered in the pages of errata, one has to wade through these forums to find the answers. One would think that the errata would be updated as the faults become apparent!
That's my only gripe, so far!

Hi sevans,

Are you working with VB or C# code? I'm guessing VB but want to check before I reply.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive

Hi Dan,
Thanks for the reply. I'm working with VB.
Looking forward to an answaer to my problem.
Regards

Hi sevans,

OK, the brief answer is that if you update say the opposition team in one control (say, the GridView) it won't be reflected in the other control (say, the DetailsView) because the values shown in that control are stored in ViewState and aren't refreshed until you either reopen the browser or force the page to update the viewstate for that control by making it change - the easiest way to do it is to try and edit the same match details in the control and when you click edit, the value you changed in the other control will appear in the other one.

So why does it work this way? Basically, it's to reduce the number of times data is retrieved from the database - if the two controls used the same datasource, they would both update, but they don't.

Is there a way to change this? Yes. You can disable ViewState for both GridView and DetailsView in two ways.

1. Select the GridView in design view on fixtures.aspx. In the properties window, set EnableViewState to false. Repeat for the DetailsView.
2. Switch to code view for fixtures.aspx. In the top line <% @Page ... /> add EnableViewState="false" among the properties. VWD's autocomplete will help here.

Note that option 2 switches ViewState off for the entire page here, and not just the GridView and DetailsView. This doesn't matter too much for this page as it's just a demo for updating data to a database but I think it's worth noting that sometimes this isn't always the best thing.

Anyway, I hope that helps.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive

Hi Dan,
Thanks for the reply and it works a treat; Did I miss something in the text?
Regards
sevans

I checked the text as well - I don't think so.

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive

Actually yes I believe you missed something in the text. On page 277-278 it talks about this refreshing problem.

To solve this, you would have to insert the DataBind() method in each of the controls. Once you do that, it will then refresh the other data in other controls.