I have to display data in the datagrid from a table which may have 13 million records.I have found a way to display only 50 records at a time in the datagrid By using Paging in Datagrid(VB.NET control)
ie. sql querying (select top 50 * from table....)
But for navigation instead of providing "Previous" and "NEXT" buttons i want to identify the user clicks in the Scroll bar of the Datagrid and reload the datagrid ie.when they click to scroll downwards i want to load the next page and when they click at the top of scroll bar i want to load previous page.
There is a Scroll event in the datagrid but there are no methods i find in them to control user actions.Can somebody help me in this.