Michael,
Well, since no one has answered your question yet, I guess I'm going to have to jump in and at least give you some pointers. I've not used the DataGridView much at all so I can't speak from experience yet (I plan to do more with it soon, though).
Do a Google search on "paging DataGrid" and you'll find plenty of articles on paging DataGrids. Unfortunately, a lot of them are for ASP.NET DataGrids, so you'll have to weed out those (or just do your search on "paging DataGridView" instead, although you'll miss the ones targeted to the older DataGrid). Here's a few I found for WinForms DataGrids and DataGridViews:
DataGrid
http://www.codeproject.com/useritems/DataGridPaging.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpagingthroughqueryresult.aspDataGridView
http://www.eggheadcafe.com/community/aspnet/2/10009945/paging-a-windows-forms-da.aspxhttp://www.codeproject.com/vb/net/WinFormGridviewCaching.aspShould be enough to get you started. Also, if Kevin Goff would jump into this thread, he might be able to give you a few more pointers ... I know he's told me that this paging stuff works great, so I'm pretty sure he knows more about how to do it.
~~Bonnie
>I do have a legacy Foxpro application where it was possible ( and was quite easy ) to browse a reference file(s) having them sorted on each column. Also entering a single symbol in text boxes situated above respective columns allowed to jump to the first record which start from that symbol with automatic resorting.
>Though for small tables it shouldn't be problem to load everything into a grid and then be able to do same , it is not going to work for large tables.
>
>I understand that Datagridview has a virtual mode which is not really the same behaviour. Probably certain search criteria should be imposed for entering before browsing or probably paging needs to be introduced. Just wondering whether someone has described already the possible strategies to keep existing users happy after moving to .Net
>
>TIA
>Michael
