I currently developed a window form application using data binding concept.
Due to there are too many records (> 50K) in the database table, it take very long to load the form.
I am looking for a solution to partially fetch the record from database.
My idea is to fetch first 100 records when form is loaded. When user navigates (using binding navigator) the record let's say until record number 90, it will automatically fetch another 100 records. Same concept applies to datagridview. If user scroll down the scrollbar of a datagrid let's say scrolling until 3/4 of the scroll area, it will automatically fetch more record and shown in the grid.
Can anyone of you guys know about how to do it?