Retrive data from database(oracle) according to pagination

Question

I have a Patient Table holding records. Now while displaying the records how can i apply pagination and retrieve data according to page size and page number? I mean to say for example I want to display 5 records in a page then in page 3 only rows 11-15 will be retrieved from the database and will be binded to the gridview instead of retrieving all th rows from database. The reason to do this is to avoid to retrieve large number of data and intead retrieve according to the PAGE SIZE and PAGE NUMBER. What will be the Oracle Query and the code in asp.net?

Ankit Sharma · Answer

you can go through these links to get some idea https://stackoverflow.com/questions/11543538/very-large-amount-of-data-on-gridview-in-asp-net https://docs.microsoft.com/en-us/aspnet/web-forms/overview/data-access/paging-and-sorting/efficiently-paging-through-large-amounts-of-data-cs https://stackoverflow.com/questions/38758127/using-paging-in-handling-the-large-amount-of-data