I have a .NET web app where I will be displaying records retrieving from an SQL database
As I try to make the connection to the Datatabase, I found an issue that the records could not be displayed in the UI because out of memory error occurred as too many records (nearly 20000) would be retrieved from database. How can I make adjustment to the code that only top 100 records will be showed on the page, and the other records can be searched from database by entering keyword in the Search box at top-right corner of the Datatables
Thank you!