C# dataGridView select 100 by 100 rows

Question

I have a problem with dataGridView in C#. I want to select 100 by 100 rows of data. The table is very big with 100000 rows and growing. So if i select all rows it takes too long to fill the dataGridView.

So on start i would select 100 rows, and when the user comes to the 100 row it has to select 100 another rows, when he comes to 200 row, another 100 and so on...

Now i'm doing this like:

SELECT a.vz_id, a.ste_rac_nal, a.ste_pak, a.dat_pak, A.ISO20022_53_VALID, A.ISO20022_53_IZPISEK
                FROM VZ_IZPISKI a
                where rownum < 100
                order by A.VZ_ID desc

If you don't understand what i mean please comment

have fun http://msdn.microsoft.com/en-us/library/bb445504.aspx — Paul Zahra, May 15 '13 at 09:42
You can look at here: http://stackoverflow.com/questions/1334799/using-a-background-worker-update-a-progressbar-on-the-progress-of-a-recursive — Toan Vo, May 15 '13 at 09:42
@Marko Leben: So are you want ask about SQL or the way working on Window forms? or asp.net? — Toan Vo, May 15 '13 at 09:44
If about SQL paging at server side. Look at here: http://stackoverflow.com/questions/14384540/server-side-paging-in-sql-server — Toan Vo, May 15 '13 at 09:46

score 0 · Accepted Answer · answered May 15 '13 at 10:03

0

Implement paging on server side. You should only return the data that user is viewing currently. It will increase responsiveness of your application as well.

answered May 15 '13 at 10:03

Ehsan

31,833
6
56
65

OK i'll try. tnx for your answer – Marko Leben May 15 '13 at 10:15

C# dataGridView select 100 by 100 rows

1 Answers1