/ Published in: C#
Call it in the button click event after in(de)crementing CurrentPage value
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
DataTable dtAllProductsView = DB.GetData(@" SELECT TOP " + itemsNb + @" * FROM (SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber, * FROM [vwAllProductData] WHERE [" + promotion + @"] LIKE 'True' AND active = 'True' ) _rowNbResult WHERE RowNumber > " + CurrentPage + @" * " + itemsNb);