Number of records in SqlCeResultSet

[Veprus]

I have a SqlCeResultSet which i bind to DataGrid. Is there a way to
somehow retrieve a number of records that was "Selected" with the SQL
query? (I assume that the information has to be available somewhere,
because the DataGrid adjusts its vertical scrollbar according to
number of results)

 

[Guest]

You can use the SqlCeResultSet.GetList( ) to get the ResultSetView and then
use the count property of ResultSetView to get the number of rows. Se
http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.resultsetview_members.aspx for details.

Rick D.
Contractor

 

[sankarann]

Hi,
The above info are very useful.

Now am facing a problem that how to get the properties in a SqlCeResultSet class using Property driscriptor??

Thanks in advance..