EDN Admin
Well-known member
Hi,
I have Windows 7 64 bit OS and MS visual studio 10. I build a C# Windows Form app that loads data from Excel 2010 using a System.Data.OleDb connection and a provider = Microsoft.ACE.OLEDB.12.0 and EXCEL 12.0 Xml; HDR=YES into a datagridview. That works in so far as the number of rows in Sheet1 does not exceed 12,000. I also tried paging but the initial load still cant exceed 12,000 rows. And that is the problem. There are times when the data can be up to 150k rows. My question is: is there a way to load that massive amount of data into a datagridview for viewing or a better way to do paging?.
View the full article
I have Windows 7 64 bit OS and MS visual studio 10. I build a C# Windows Form app that loads data from Excel 2010 using a System.Data.OleDb connection and a provider = Microsoft.ACE.OLEDB.12.0 and EXCEL 12.0 Xml; HDR=YES into a datagridview. That works in so far as the number of rows in Sheet1 does not exceed 12,000. I also tried paging but the initial load still cant exceed 12,000 rows. And that is the problem. There are times when the data can be up to 150k rows. My question is: is there a way to load that massive amount of data into a datagridview for viewing or a better way to do paging?.
View the full article