折腾N天了,搞不定,请高手赐教~!谢谢~!我用的是C#,代码请用C#写,VB,的看不太懂,谢谢了~!对数据库排序后如何选取其中连续的一段?
如何实在分面显示?
谢谢~!@
如何实在分面显示?
谢谢~!@
解决方案 »
- 关于url重写以及电子商务开发实战这本书
- dropdownlist绑定目录???
- webform中GridView怎么实现固定列宽,多余的数据就显示为...,象winform的dataGridView一样,双击显示全部数据?
- 创建cookies的问题,请教高手。
- asp.net程序中新建文件夹之后重新加载页面Session丢失是怎么回事?
- -------判断一字符串是否满足如下格式------------
- 关于调用webservice响应时间过长出黄页
- 在daragrid中加了delete列,但是处理事件始终不响应,请各位帮帮忙!
- 关于日期转换
- ASP.NET大小写转换问题
- 在webform中实现弹出保存可打开对话!
- 还是刚刚的img和fileupload的问题
按照向导设置就行了,很容易的。
(
SELECT OrderID,
CustomerID,
OrderDate,
ROW_NUMBER() OVER(ORDER BY orderID ASC) AS 字段编号
FROM dbo.Orders WITH(NOLOCK)
)SELECT * FROM OrdersByOrderIDASC WITH(NOLOCK) WHERE 字段编号BETWEEN 100 AND 110
--分页存储过程,在C# 中调用 传入相应的参数 就可以取指定页和大小的数据了
Create PROCEDURE [dbo].[Pagination](
@PageSize INT, --每页的记录条数
@PageNumber INT, --当前页面
@QuerySql VARCHAR(8000),--部分查询字符串,如* From Test order by id desc
@KeyField VARCHAR(500))--一般用主键
AS
BEGIN
if @PageNumber is null or @PageNumber<1
Begin
Set @PageNumber=1
End
DECLARE @SqlTable AS VARCHAR(8000)
DECLARE @SqlText AS VARCHAR(8000)
SET @SqlTable =N'Select Top ' + CAST(@PageNumber * @PageSize AS VARCHAR(30)) + ' ' + @QuerySql
SET @SqlText = N'Select Top ' + CAST(@PageSize AS VARCHAR(30)) + ' * From ' + '(' + @SqlTable + ') As TembTbA ' + 'Where ' + @KeyField + ' Not In (Select Top ' + CAST((@PageNumber - 1) * @PageSize AS VARCHAR(30)) + ' ' + @KeyField + ' From ' + '(' + @SqlTable + ') AS TempTbB)'
Print @SqlText
EXEC( @SqlText)
END
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY score DESC, name) AS rownum,
name,score
FROM Tb) AS D
WHERE rownum BETWEEN 4 AND 6
ORDER BY score DESC, name
或
create procedure procPage @startIndex int,@endIndex int,@sort varchar(50)='asc'
as
if @sort='asc'
begin
with pageTamp as(
select row_number() over(order by id asc) as row,* from dbo.Tb)
select * from Tb where row between @startIndex and @endIndex
end
else
begin
with pageTamp as(
select row_number() over(order by id desc) as row,* from dbo.Tb)
select * from Tb where row between @startIndex and @endIndex
end