Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Reply
how to used sql server query in asp.net
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Asad khan
7y
211
1
Reply
used this query in asp.net for pagination?
DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 4
SET @RowspPage = 500
SELECT [Id]
,[Name]
,[UserName]
,[Password]
,[Gender]
,[Age]
,[Address]
FROM [Regdb].[dbo].[TblReg]
ORDER BY [Id]
OFFSET ((@PageNumber - 1) * @RowspPage) ROWS
FETCH NEXT @RowspPage ROWS ONLY;
And my asp.net select query is that,
System.Data.SqlClient.SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter("select top ("+ PAGESIZE + ") * from TblReg ", con);
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Calling controller's action using AJAX/Jquery
asp.net mvc using entity frame work how can i prepare login