Hello all,
I have been using VB.NET 2005 for the past month or so, and created a project which utilises the Datagridview.
The project reads a number of access tables and allows the user to edit, update, add etc...
All works without problem until I decide to read a table with a number of records in it (20k onwards). The connection to the database is made, the DataAdapter fills a dataset and the dataset populates the datagridview.
The dataset gets populated within a second, but the problem lies in populating the datagridview.
If the dataset is populated so quickly, why does it take forever to populate the dataset (roughly 4 minutes). I know that it is not down to access because if I filter the data down to 100 records it is almost instantaneous.
Other than painting the number of records only shown in view in the first instance - and then redrawing each time the user scrolls down, I am drawing a blank.
I have been using VB.NET 2005 for the past month or so, and created a project which utilises the Datagridview.
The project reads a number of access tables and allows the user to edit, update, add etc...
All works without problem until I decide to read a table with a number of records in it (20k onwards). The connection to the database is made, the DataAdapter fills a dataset and the dataset populates the datagridview.
The dataset gets populated within a second, but the problem lies in populating the datagridview.
If the dataset is populated so quickly, why does it take forever to populate the dataset (roughly 4 minutes). I know that it is not down to access because if I filter the data down to 100 records it is almost instantaneous.
Other than painting the number of records only shown in view in the first instance - and then redrawing each time the user scrolls down, I am drawing a blank.