Gridview & FormView Show New Record WITH Paging

Question

Using: VS2005 for Web Development C# I have a Gridview bound to a FormView (or DetailsView if you like). After I add or update a record how do I get the Gridview AND Formview to display that record? If it is on the same page you can just do a Databind(). But what if the record added ends up on page 3 of the Gridview and you are currently on Page 1? I have yet to see a satisfactory answer to this question. There was some discussion on http://forums.asp.net/p/1063022/1956479.aspx#1956479 but I don't think it was a complete solution for this. Plus some of the coding I didn't understand (i.e. Case Gridview1) I cannot imagine that I am the only one who wants to put this in. I would have thought it would be VERY easy with ASP.NET with all its other shortcuts. Even though it is kind of a detail -- the web page WORKS but it just makes sense for it to do this. Thanks in advance for any help on the topic!

Nour Berro · Answer

well I didn't understand exactly what u need but i think i have a solution for ur problem.. u can add in inserted event sql statment select MAX record ID in the Data table then bind it to the formView

Anna Hawks · Answer

And NO ONE has a solution? I would think this would be a common request. It would be confusing to add a new record on formview and have a completely different page on the gridview showing right next to it.