Does anybody know how to get a number of rows when using DataTable
with datasource that is an SqlCeResultSet.
I use the following code to "select" the data into DataTable:
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Customer";
SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Scrollable);
dgrData.DataSource = rs; //dgrData is DataTable