Regarding MVC and SQL

Question

Hello Everyone, In SQL I have total 1500 records. I am using search filtration on the webpage. In code, it shows me proper 1500 records, but while on the webpage it only displays top 300 records (Pagination is working). Rest of the data is missing on the webpage. I am using MVC OrmLite and SQL database server. I have verified data and data is fine. So needed help to fix this and also wanted to know what I'm missing here. Thanks in advance !!!

Munesh Sharma · Answer

go throught with following links https://stackoverflow.com/questions/34672944/paging-all-results-in-servicestack-ormlite https://www.c-sharpcorner.com/UploadFile/0c1bb2/crud-operations-in-Asp-Net-mvc-5-using-dapper-orm/

Salman Beg · Answer

Hey. Could you please share your code as well as stored procedure etc so that I can check it once. Thanks.

Guest User · Answer

I did that without pagination, still, the issue is there. It still displays around 300-400 records only. But the query brings all records and it is more than 400. Thanks

Guest User · Answer

Yeah,I can try without pagination. But I had also debug the code in inspect element screen and I didn't find anything wrong,but still I will look at it again. I will surely let you know the status.Thank you for your kind reply though !!!

Guest User · Answer

Yeah,I can try without pagination. But I also debug the code in inspect element screen and I didn't find anything wrong,but still I will look at it again. I will surely let you know the status. Thank you for your kind reply though !!!

Salman Beg · Answer

Can you remove the pagination and check how many records are loading because it may be a issue with pagination. There might be a issue with any client side script also and for that press F12 or Inspect Element in the browser and check it. thanks

Guest User · Answer

In debugger it shows all records (1500) from database.But somehow it only displays maximum 300 or 400 records. I have checked almost all possible things.still no luck !!!

Salman Beg · Answer

Hey can you put a debugger in data table and check how many records are coming from db to data table. thanks

Guest User · Answer

Hey thanks for a quick reply . But i am not using Top 300 in my sql query.When i am using Top 300,it displays records in webpage datatable.Otherwise,all records are not displaying on webpage. Thanks in advance !!!

Salman Beg · Answer

Hi. I think in sql query, are you using top 300 like this?. If you are using top 300 like this then remove it and which will fetch all the 1500 records. As you are using pagination so based on the page size it will load that much number of records. Thanks

Regarding MVC and SQL

Answers (10)