Devart Forums

Hi,
I'm wondering if it is possible to find out the total number of rows that will be fetched by a uni-directional dataset without having to use "select count(1) from ..." or using FetchAll or something else that loads all rows. I want to do some optimizations in my code when there are less than ~100 rows that will be fetched.

Thanks for any help.

Eric

Hello,

To get the total record count you should set the QueryRecCount option to true.
In this case the following SQL statement 'SELECT COUNT(*) FROM ...' will be called automatically.

Thanks for the hint. It was a big help.

Hello,

It is good to see that this problem was solved. If any other questions come up, please contact us.