Get Page wise record in SQL Server 10 records each page
;with pagewise as
(
SELECT ROW_NUMBER() OVER(ORDER BY id) AS rowno, ID, roww, name, city
FROM Student ) select * from pagewise where rowno>9 and rowno<21 order by rowno
Get Page wise record in SQL Server 10 records each page
;with pagewise as
(
SELECT ROW_NUMBER() OVER(ORDER BY id) AS rowno, ID, roww, name, city
FROM Student ) select * from pagewise where rowno>9 and rowno<21 order by rowno
while Submit HTML Content thorugh Form post method is now allowed because ASP.Net Stop IT to prevent RSS Attack So you will have to tell ASP.Net form to process HTML Data .. steps are given below .
Session["ID"]
= "lorem";
Session["Amt"] = 123;