C# dataGridView select 100 by 100 rows -


i have problem datagridview in c#. want select 100 100 rows of data. table big 100000 rows , growing. if select rows takes long fill datagridview.

so on start select 100 rows, , when user comes 100 row has select 100 rows, when comes 200 row, 100 , on...

now i'm doing like:

select a.vz_id, a.ste_rac_nal, a.ste_pak, a.dat_pak, a.iso20022_53_valid, a.iso20022_53_izpisek                 vz_izpiski                 rownum < 100                 order a.vz_id desc 

if don't understand mean please comment

implement paging on server side. should return data user viewing currently. increase responsiveness of application well.


Comments