SQLCEResultSet and DataGrid - Initial loading time problem

[Prabhu]

This Post was taken from thread :
http://groups.google.co.uk/group/mi...read/thread/6f1fa4618ed76f52/6b6936026c51ff49

"There is no DataGridView in NETCF, only a simple DataGrid.

If you're using SQL Mobile as your data base, you can use DataGrid and
SqlCeResultSet classes, it works exactly the way you want.

For other DBs that can be done by creating custom data source class
which
implements IBindingSource.

DataGrid would tell you which records it wants via this interface, so
you
could go ahead and retrieve them as needed.

Total number of records needs to be reported to the grid and can be
queered
by using respective data base means (e.g. COUNT keyword in SQL query).

Best regards,

Ilya"

My situation is similar. I am facing initial loading time problems with
datagrid on querying a large amount of records. I am using
sqlceresultset and still it takes about 4 seconds for 4K records. Is
there any way we can do a Top query or select a particular range of
records from the sqlce 3.0 database (other than having a id field).
Your help on this issue is greatly appreciated. Thanks.

Regards,
Prabhu

 

[Ginny Caughey [MVP]]

Prabhu,

The DataGrid already only displays the visible rows, so if the query is
taking too long, get the user to tell you what he's interested in before you
attempt to display a huge resultset. You can use TableDirect to specify a
range of records, but of course be sure you have an index over the value
that you will be using for the range.