8,497
社区成员
发帖
与我相关
我的任务
分享
var movies = (from m in db.Movies
where m.ReleaseDate > new DateTime(1904, 6, 1)
orderby m.ID
select m).Skip(90).Take(10);
return View(movies.ToList());
--LinQ SQL
SELECT TOP 10 A.*
FROM ( SELECT
* ,
ROW_NUMBER() OVER ( ORDER BY sd_Key ASC ) ROWS
FROM dbo.sys_Dictionary
) A
WHERE A.ROWS > 90
--ADO.Net手动传入的SQL
SELECT A.*
FROM ( SELECT TOP 100
* ,
ROW_NUMBER() OVER ( ORDER BY sd_Key ASC ) ROWS
FROM dbo.sys_Dictionary
) A
WHERE A.ROWS > 90
public static DataTable GetTableByWhere(int PageSize, int PageIndex)
{
string strSQL = string.Format(@"SELECT TOP {1} *,
ROW_NUMBER() OVER ( ORDER BY sd_Key ASC ) ROWS
FROM dbo.sys_Dictionary
) A
WHERE A.ROWS > {1}", PageIndex * PageSize, (PageIndex-1) * PageSize);
....
}
--ADO.Net手动传入的SQL
SELECT A.*
FROM ( SELECT TOP 100
* ,
ROW_NUMBER() OVER ( ORDER BY sd_Key ASC ) ROWS
FROM dbo.sys_Dictionary
) A
WHERE A.ROWS > 90
var dicts = (from m in db.sys_Dictionary
orderby m.sd_Key
select m).Skip(90).Take(10);