HI
I use these code to my datalist pagination
http://www.aspsnippets.com/Articles/Custom-Paging-in-ASP.Net-GridView-using-SQL-Server-Stored-Procedure.aspx
in my page i have 2 datalist with 2 different StoreProce and i have 2 button
I put these code for my button
protected void Imgbtn1_Click(object sender, ImageClickEventArgs e)
{
DataList1.Visible = true;
DataList2.Visible = false;
}
AND
protected void Imglastpro_Click(object sender, ImageClickEventArgs e)
{
DataList2.Visible = true;
DataList1.Visible = false;
}
in whole when datalist1 is show on page datalis2.visible=false
now i want use pagination for both of them but i dont know how i can do it?
I just use pagination for datalist1 how i can do for my second datalist
I use this SP for my datalist 1
ALTER procedure [dbo].[GetCustomersPageWise]
@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [ID] ASC
)AS RowNumber
,[ID]
,[Name]
,[Image]
,[Model]
INTO #Results
FROM [House_p]
SELECT @RecordCount = COUNT(*)
FROM #Results
SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
DROP TABLE #Results
END
and for my datalist2 i need these column
select Name,Description,Image,Address
from House_info
how i can do it?
thanks alot