Does somebody know how to obtain the recordcount from a SqlCeResultSet ?
Thanks in advance!
See this.
|||Ilya,
Please could you explain your post a little more, since I cannot make it to work.
int rowCount = ((IBindingList)resultSet.ResultSetView).Count;
I'm using VS 2005, Net CF 2.0 SP2 and SQL CE 3.1
thanks in advance!
|||I’m not quite sure what to explain here, this single line of code is rather primitive. Let me try it: you get ResultSetView from ResultSet, cast it to IBindingList and get Count property which contains number of records.
Are you a VB developer? If so use any free online C# to VB converter to get VB code.
|||
int count = ((System.Collections.ICollection)rs.ResultSetView).Count;
You could try using above line to get the row count of the ResultSet.
