c# - Paging, sorting and filtering in SQL Server 2005 -

can please explain me custom paging, filtering , sorting . though have searched on internet these things ways difficult understand. body have better approach paging, filtering , sorting in single query. how able things in single query have created grid using forloop. , how can paging , filtering custom.i have checked loginc hav not understood . row number being used in many of examples of paging online. can please explain this. sorry poor english. please me asap. thank you.

i find grids easiest way display large amounts of data. try googling examples of asp:gridview. basic functionalities grid automatically adds (when enable paging) are:

• previous page, next page , similar buttons move between pages
• max page/item count
• current page

an important not on paging:

• client side paging: load all data @ once, display 10/15/20/... items @ once
• server side paging: load page viewing (so every time go different page there database call needed)

generally, client side paging 'default'. give list grid, set number of items want see per page , you're done. works enough small tables (a few dozen items), if scales poorly. if have million items in table, try (and fail) load of them before displaying anything.

you can put hard limit on how many items show, best way handle large tables server side paging. this, customization needed though. here 'rownumber' mentioned needed (server side paging example). having rownumber lets fetch 'page'. example:

• page: 5
• total (number of records): 100
• pagesize (number of records shown per page): 10

if want records page 5, need sort list somehow , take records 41 50 show content of page 5. in query, done rownumber between ((page - 1) * pagesize) + 1 , page * pagesize. in entity framework can use .skip((page - 1) * pagesize).take(pagesize) same result.

note: paging assumed start @ 1 (first page = page 1) in above example.