Regarding MVC and SQL

Guest User

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 !!!

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma7y ago
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 Beg7y ago
Hey. Could you please share your code as well as stored procedure etc so that I can check it once. Thanks.
Guest User7y ago
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 User7y ago
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 User7y ago
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 Beg7y ago
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 User7y ago
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 Beg7y ago
Hey can you put a debugger in data table and check how many records are coming from db to data table. thanks
Guest User7y ago
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 Beg7y ago
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