Hi. I am attempting to display the contents of a database table on a CE
device. I was using a DataTable object, as the datasource of the DataGrid,
to accomplish this task. The problem with this approach is that I need to
read the whole table into memory before assigning it as the datasource of
the DataGrid. Ideally, I should retrieve row by row as needed to save
memory.
Conceivably I could read a partial # of rows and refresh the DataTable
object with the new data during run-time, as needed. However, the problem
with this approach is that the DataGrid will think that the total table size
is only that many rows. For ex: if the database in total has 1000 rows and I
am only assigning 10 rows at a time to my DataGrid datasource (in the form
of a DataTable), the DataGrid's scroll bar will only reflect 10 rows.
I am presently trying to use the iList interface to solve this problem.
Unfortunately, I couldn't find any documentation on how I can simulate the
2D nature of the DataTable using the 1D iList interface.
If someone can help me with this or see a problem with my train of thought,
that would be great. Thanks!.
Chankama