ASP.net
Awesome
Learn
Forum
Buy
Demos
Sign In
☾
☀
Switch to
Dark
Light
Mode
this site works best with javascript enabled
Ask Question
Grid Paging Question
Title:
B
I
{code}
?
Hello, Can your grid paging control limit the number of records that are fetched from the database. For example, if we have a dataset of 5000 records, if it possible to just fetch the top 100 records and then click on the next button so that we can query the database to retrieve the next 100 records and so on. If it does, does it happen at the SQL level (example, does it generate a SQL statement such as "Select TOP 100 FROM .....") or is the whole dataset first retrieved and the paging control takes over? Thanks!
Save Changes
Cancel
Deep
asked at 11 Feb 2016
that's how it works by default, if you're using EF or something else that supports Linq, it only fetches the rows that is showing (10 rows), you click on page 2 and another 10 rows are fetched
at 12 Feb 2016
Omu
Answers
please
Sign In
to leave an answer
By accessing this site, you agree to store cookies on your device and disclose information in accordance with our
cookie policy
and
privacy policy
.
OK
