Large dataset and listview population

[Michael Jackson]

Hi all,

I'm looking for a solution to my problem where I have a large dataset
(65,000 rows or more), with many columns. I populate a listview control with
the data, however, the population of the listview never completes, and
sometimes, error's out.

I'm assuming I need some sort of paging scheme, but don't know how to
implement such a scheme.

Any pointers to articles, how-to's, etc would be greatly appreciated.

Thanks,

Michael

 

[Cor Ligthert [MVP]]

Michael,

65.000 rows in an UI seems for me madness. What do you want that your user
do with this, give him a way to select that by instance using comboboxes.

And than 'Where' clauses in your select assuming it is an online
application.

Just my thought,

Cor

 

[Sahil Malik [MVP]]

You must be using .NET 1.1. .NET 2.0 will not give this problem.

For .NET 1.1, simply use a DataView for easy paging and only databind a few
rows. Just google for "DataView Paging".

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

 

[Guest]

Hi,
You need to use a scrollable server cursor for a large data table. You
can't get it from ADO.NET. However, you can use OleDBProNet at
www.udaparts.com for your solution.