Hi all!
Please help me - how organize sorting data in gridview if data getting from stored procedure? In gridview set AllowSorting="True". For example - user clicks to sort some column and data sortings?
USE [test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[test]
@PageIndex INT = 1
,@PageSize INT = 10
,@RecordCount INT OUTPUT
,@Region nvarchar(60) = NULL
,@City nvarchar(60) = NULL
,@Price INT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY Id_member ASC
)AS RowNumber
,Id_member
,Region
,City
INTO #Results
FROM
ProfilePicture inner join Profile on Profile.Id_member = ProfilePicture.IdMember left join ProfileShop on
ProfileShop.Id_member = ProfilePicture.IdMember and (P ...
Go to the complete details ...