How to Implement PagingSorting and Filtering methods in DAL

Question

HI Guys I have been given a task of implementing SortingPaging and Filtering methods in the DAL layer of our project not in the UI part in the UI only these methods will be called  i tried finding the answer on Google but failed  can anyone suggest some of their great ideas...help will be appreciated as this task is required on the urgency basis....Thanks........

Dorababu Meka · Answer

Hi you can write the code you required for Paging or what ever in you DAL just as like we do for insert update delete and you can call that function in the event you required. check these articles http://www.aspsnippets.com/Articles/Custom-Paging-in-ASP.Net-GridView-using-SQL-Server-Stored-Procedure.aspx http://www.c-sharpcorner.com/UploadFile/3d39b4/custom-paging-in-gridview/ and write the code you required in DAL

How to Implement Paging,Sorting and Filtering methods in DAL