Custom Paging Stored Procedure with Custom Sorting in SQL Server

eformx

SOLVED CLOSED ACTIVE ANSWERED
User: eformx
Posted: on Apr 12, 2013 12:27 AM
Forum: SQL Server
Answer: 1
Views: 3253

This works well:

http://aspsnippets.com/Articles/Paging-in-ASPNet-GridView-using-jQuery-AJAX.aspx

but how would I add dyamic sorting so if user were to click a column then sort by it in asc or desc. And if possible can a filter be passed to all columns in a Like in that stored procedure?

Thanks!

Rob

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Apr 12, 2013 12:33 AM
Report

You can add a @SortDirection Parameter and do as follows

SELECT ROW_NUMBER() OVER
			(
				ORDER BY 
				 CASE WHEN @SortDirection = 1 THEN [CreatedDate] END ASC
				,CASE WHEN @SortDirection = 2 THEN [CreatedDate] END DESC
			) RowNumber

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Custom Paging Stored Procedure with Custom Sorting in SQL Server

Company

Explore

Follow us

Contact Us