click on link button is not working

i have a datalist which gets populated depending on the selection through,link button and radio buttons.....the link button passes the categoryid parameter,radio button-rblbrands passes the brand parameter and last radio button-rblpricerange passes the price parameter....

when the page loads,and i scroll selecting any thing,the scroll works fine...but when i click any link button second time,the categoryid,PageIndex and the PageCount doesn't changes,it holds the value of previos selection ..PageCount is output parameter,depending upon the data populated in the datalist....and if there any good way to shorten my stored procedure.....its very large....

here's my code,hope u understand....,

thanks in advance.......

My Stored Procedure

ALTER PROCEDURE Getproducts

@PageIndex INT

,@PageSize INT

,@CategoryId int

,@Brands nvarchar(50)= null

,@Price int

,@PageCount INT OUTPUT

AS

BEGIN

DECLARE @RecordCount INT

DECLARE @pricestart INT

DECLARE @priceend INT

if(@Price = 1)

begin

set @pricestart = 1

set @priceend = 2000

end

if(@Price = 2)

begin

set @pricestart = 2001

set @priceend = 5000

end

if(@Price = 3)

begin

set @pricestart = 5001

set @priceend = 10000

end

if(@Price = 4)

begin

set @pricestart = 10001

set @priceend = 18000

end

if(@Price = 5)

begin

set @pricestart = 18001

set @priceend = 25000

end

if(@Price = 6)

begin

set @pricestart = 25001

set @priceend = 35000

end

if(@Price = 7)

begin

set @pricestart = 35001

set @priceend = 50000

end

/*On page Load*/

IF(@CategoryId = 0 and @Brands is null)

if(@Price = 0)

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #PageloadResults

FROM [Products]

SELECT @RecordCount = COUNT(*) FROM #PageloadResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #PageloadResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #PageloadResults

end

else

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #LoadpriceResults

FROM [Products] where Price between @pricestart and @priceend

SELECT @RecordCount = COUNT(*) FROM #LoadpriceResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #LoadpriceResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #LoadpriceResults

end

/*if category id is selected*/

ELSE IF(@CategoryId != 0 and @Brands is null)

if(@Price = 0)

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #CategoryIdResults

FROM [Products] where Categotyid = @CategoryId

SELECT @RecordCount = COUNT(*) FROM #CategoryIdResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #CategoryIdResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #CategoryIdResults

end

else if(@Price != 0)

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #CategoryIdpriceResults

FROM [Products] where Categotyid = @CategoryId and Price between @pricestart and @priceend

SELECT @RecordCount = COUNT(*) FROM #CategoryIdpriceResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #CategoryIdpriceResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #CategoryIdpriceResults

end

/*Brands is selected*/

IF(@CategoryId != 0 and @Brands is not null)

if(@Price = 0)

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #BrandsResults

FROM [Products] where CategotyId = @CategoryId and Name LIKE @Brands + '%'

SELECT @RecordCount = COUNT(*) FROM #BrandsResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #BrandsResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #BrandsResults

end

else

begin

SET NOCOUNT ON;

SELECT ROW_NUMBER() OVER

(

ORDER BY [ProductId] ASC

)AS RowNumber

,[ProductId],[Name],[Description],[ImageUrl],[Price],[categotyId],[quantity] INTO #BrandspriceResults

FROM [Products] where Categotyid = @CategoryId and Name LIKE @Brands + '%' and Price between @pricestart and @priceend

SELECT @RecordCount = COUNT(*) FROM #BrandspriceResults

SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))

PRINT @PageCount

SELECT * FROM #BrandspriceResults

WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #BrandspriceResults

end

END

My code ;