gridview - ASP.NET Custom Paging -


How to keep custom paging for dynamic result sets? (I.e.) 10 dropdown selects my stored procedure dynamically based on selection, but it generates millions records.

The row is statically known as record count, cues paging is efficient, but how to achieve it for a dynamically increased result set

The problem

< P> I have to pair the general list with gridview, the columns are fixed, but the number of retuened rows is unknown, but the result for carrying my GridView 30 minutes without custom paging. You should use LINQ if possible, as extensible operations do for easy paging.

Then you have a IQueryable & lt; T & gt; is the method that accepts an initial status and the number of rows to retrieve.

Then you skip () and take () to get simple paging.

Very good article on doing this.

Remember that skip () and take () come in front of any class that applies IEnumerable, therefore, the above article is called LINQ- Use SQL for your data repository, unless your own DAL exposes a type of archive IEnumerable , you can skip and take patterns.

Hope that helps.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -