asked on What is the best way to paginate where I can pass my existing sql statement as a variable
so existing mySQLStatement could be passed in as a variable to a c# function?
mySQLStatement="Select field1,field2 from myTable";
myNewSQLwithPagination=con
Basically I am asking how to generalize pagination by passing simple queries?
I use mssql
mySQLStatement="Select field1,field2 from myTable";
myNewSQLwithPagination=con
Basically I am asking how to generalize pagination by passing simple queries?
I use mssql
Web Languages and StandardsDatabasesC#ASP.NETSQL
Last Comment
goodk
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I liked the link but I could not quite gather how I would use to crate a generalized function?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Please see my original question. If any one has an answer. I am sure many people had written a function of the sort otherwise one has to write each and every query for pagination.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
How MS access does paging as we only submit a simple sql?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
With MYSQL , you can use limit and startpoint
e.g.
SELECT * FROM tblOrders ORDER BY datetime ASC LIMIT 1 , 20";
With MSSQL, you can use ROW_NUMBER()
SELECT *
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
FROM Orders
WHERE OrderDate >= '1980-01-01'
) AS RowConstrainedResult
WHERE RowNum >= 1
AND RowNum < 21
ORDER BY RowNum
e.g.
SELECT * FROM tblOrders ORDER BY datetime ASC LIMIT 1 , 20";
With MSSQL, you can use ROW_NUMBER()
SELECT *
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
FROM Orders
WHERE OrderDate >= '1980-01-01'
) AS RowConstrainedResult
WHERE RowNum >= 1
AND RowNum < 21
ORDER BY RowNum
Important aspect in paging is have sort criteria.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am not sure if I got the answer I was looking for. I am using MSSQL shared database on godaddy.com
my front end is asp.net using VWD from MS
my front end is asp.net using VWD from MS
I want to build a generalized function where I pass sql statement and and page start and page size and it returns the sql statement which does pagination.