c# - Large datasets with unknown total rows -
i have rather interesting problem solve, , not sure how approach best way.
given such interface
public interface idatacursor { bool eof(); bool next(); bool prev(); bool first(); bool last(); int getcolumncount(); object getvalue(int columnindex); // return value given column current cursor position }
which points large data structure, , need display in grid. of virtual modes require total number of records known. doesn't work on case. can navigate back/forth.
does know of kind of datasource implementation implement similar interface?
none of existing free or commercial libraries offer such possibility, of them require total number of rows.
i tried calculate number of visible records datagtidview somehow navigate through dataset , update content of underlying datasource, data won't display pretty reliable.
looking advises, thank you.
perform query select count(*) table_name my_where_cluase; , use same my_where_cluase while populating grid
Comments
Post a Comment