By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,824 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,824 IT Pros & Developers. It's quick & easy.

Winforms DataGrid with a 41,000+ records.

P: n/a
I have a DataGrid (winforms) that is bound to a table (MSDE) that has
41,000+ records in it. The form loads relatively fast and I can scroll
all of the data... However, when I click in any column of any row other
than the first one, it takes forever to go to that row, even if it's
just the next one. So I limited the query to only a certain set of data
which returned a little less than a thousand records and the form shows
at the same speed, but when I click in a row, it passes for a few
seconds.. So I know it's an issue with the amount of data... If I can
see all the data on the grid, shouldn't it be just as fast to move from
row to row as it would if it only had a few records in it? Is there
something I need to do differently?

Aaron
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes, you shouldn't be loading thousands of records. You are not supposed to
use the datatable as an in memory dataset. You are supposed to load the
data it needs into it, and have your grid display it.

"Aaron Smith" <th**********@smithcentral.net> wrote in message
news:Q0****************@newssvr17.news.prodigy.com ...
I have a DataGrid (winforms) that is bound to a table (MSDE) that has
41,000+ records in it. The form loads relatively fast and I can scroll
all of the data... However, when I click in any column of any row other
than the first one, it takes forever to go to that row, even if it's
just the next one. So I limited the query to only a certain set of data
which returned a little less than a thousand records and the form shows
at the same speed, but when I click in a row, it passes for a few
seconds.. So I know it's an issue with the amount of data... If I can
see all the data on the grid, shouldn't it be just as fast to move from
row to row as it would if it only had a few records in it? Is there
something I need to do differently?

Aaron
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.

Nov 21 '05 #2

P: n/a
Actually, I found the problem and it works fine now. Thanks anyway.

Marina wrote:
Yes, you shouldn't be loading thousands of records. You are not supposed to
use the datatable as an in memory dataset. You are supposed to load the
data it needs into it, and have your grid display it.

"Aaron Smith" <th**********@smithcentral.net> wrote in message
news:Q0****************@newssvr17.news.prodigy.com ...
I have a DataGrid (winforms) that is bound to a table (MSDE) that has
41,000+ records in it. The form loads relatively fast and I can scroll
all of the data... However, when I click in any column of any row other
than the first one, it takes forever to go to that row, even if it's
just the next one. So I limited the query to only a certain set of data
which returned a little less than a thousand records and the form shows
at the same speed, but when I click in a row, it passes for a few
seconds.. So I know it's an issue with the amount of data... If I can
see all the data on the grid, shouldn't it be just as fast to move from
row to row as it would if it only had a few records in it? Is there
something I need to do differently?

Aaron
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.


--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.