DataGridView OleDB connection to Access MDB - virtual mode

2011-05-02 Thread Ian Thomas
I have been struggling with getting a modest amount of data from an Access MDB into a DataGridView quickly. (WinForms) With a bound DGV the loading and formatting of the DGV takes 60+ seconds. With a virtual mode DGV with the MSDN caching example (just9in-time"), I can get it working perfectly wit

RE: DataGridView OleDB connection to Access MDB - virtual mode

2011-05-02 Thread Greg Keogh
Hi Ian, just fumbling here, but I've had shocking performance problems loading DataGridView when any of the columns have "size all cells to contents" (I forget the exact name) and there are many thousands of rows. You can feel the poor thing groan as it loads all the rows and then freezes as it cal

RE: DataGridView OleDB connection to Access MDB - virtual mode

2011-05-02 Thread Ian Thomas
Behalf Of Greg Keogh Sent: Monday, May 02, 2011 10:19 PM To: 'ozDotNet' Subject: RE: DataGridView OleDB connection to Access MDB - virtual mode Hi Ian, just fumbling here, but I've had shocking performance problems loading DataGridView when any of the columns have "size a

RE: DataGridView OleDB connection to Access MDB - virtual mode

2011-05-02 Thread Ian Thomas
not going to be so simple). _ Ian Thomas Victoria Park, Western Australia _ From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ian Thomas Sent: Monday, May 02, 2011 11:05 PM To: 'ozDotNet' Subject: RE: DataGridView OleDB connection to Acces

RE: DataGridView OleDB connection to Access MDB - virtual mode

2011-05-03 Thread Ian Thomas
Greg (Keogh) You may have found these things, but if not here's a reasonable collection of tips on DGV 'tuning' - http://msdn.microsoft.com/en-us/library/ms171621.aspx "Performance Tuning in the Windows Forms DataGridView Control" As mentioned before, the example code accompanying the MSDN