34,575
社区成员
发帖
与我相关
我的任务
分享
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[SelectTable]
(@pagesize int,
@pageindex int,
@user varchar(255),
@docount bit,
@rowsum int output
)
as
begin
with temptbl as (
SELECT ROW_NUMBER() OVER (ORDER BY ID desc)AS Row, * FROM TableDn O where username=@user)
SELECT * FROM temptbl where Row between (@pageindex-1)*@pagesize+1 and (@pageindex-1)*@pagesize+@pagesize
-- SELECT @rowsum=COUNT(*) FROM TableDn username=@user
-- 更好的方法
end
前台里看看
sqlcommand cmd = new sqlcommand(sql,dbconn)
cmd.ExecuteNonQuery()----返回影响的条数
这样其实已经够简单了