User-1355475649 posted
Can I add more question??
Actually I already made a stored procedure to use show grid view.
Of course, it doesn't have custom paging function.
So I tried to mix a stored procedure that you gave me(http://www.aspsnippets.com/Articles/Custom-Paging-in-ASPNet-GridView-using-MySql-Stored-Procedure.aspx)
But It's really hard and confused...
I posted mixed Stored Procedure below, please teach me how to change it...
It works well but the notice is not placed on the top of list..just aligned indexNo..
ALTER PROCEDURE [dbo].[TestCustomPaging]
@BoardID int --FK(PK in tb_BoardMaster, I have 3 Boards)
, @PageIndex int
, @PageSize int
, @RecordCount int output
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY I.BoardItemID desc
)AS indexNO
, I.BoardItemID -- PK
, I.BoardTitle
, I.UserName
, I.BoardRegDate
, I.BoardHit
, I.BoardNotice -- To verify notice or not(default value is N(not notice))
, (SELECT COUNT(FileID) FROM tb_AttachedFiles A WHERE A.BoardItemID = I.BoardItemID) AS FileCount
INTO #Result
FROM tb_BoardItem I
WHERE BoardID = @BoardID
ORDER BY
I.BoardNotice DESC, indexNO DESC
SELECT @RecordCount = COUNT(*)
FROM #Result
SELECT * FROM #Result
WHERE
indexNO BETWEEN (@PageIndex -1) * @PageSize +1 AND (((@PageIndex -1) * @PageSize +1) + @PageSize) -1
DROP TABLE #Result
END
