asp.net ´æ´¢¹ý³Ì£¬ÎÒÒª·µ»Ø¼Ç¼¼¯£¬ºÍ¼Ç¼×ÜÊý

SQL code:

create proc ok
@pagesize int,
@pageindex int,
@pagetable nvarchar(50),
@RecordTotal int output
as
declare @sql nvarchar(500)
declare @StrTotalSQL nvarchar(500)

set @StrTotalSQL='select @RecordTotal=count(*) from t1'
-- '+@RecordTotal+'=

begin
set @sql='select top '+str(@pagesize)+' * from '+@pagetable+' where userid not in(select top '+str(@pagesize*(@pageindex-1))+' userid from '+@pagetable+')'
end

execute(@sql)
execute(@StrTotalSQL)
--ÎÒÒª·µ»Ø¼Ç¼¼¯£¬ºÍ¼Ç¼×ÜÊý¡£ÎÒµ÷Óò»ÁË£¬Õâ¸ö¼Ç¼×ÜÊý£¬ÊDz»ÊÇд´íÁËʲô£¬¶¨»¹ÊÇ£¬ÎÒµ÷ÓÃÓÐÎÊÌ⣿ϣÍûÓÐÈËÖ¸µã¡£

---

¿´ÉÏÈ¥Ó¦¸Ãû´í£¬ÄãÖ±½ÓÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÕâ¸ö´æ´¢¹ý³ÌÄܵõ½ÕýÈ·µÄ½á¹ûÂð£¿

Äã¾ßÌåÊÇÔõÑùµ÷Óõģ¿

---

C# code:

public SqlDataReader ok(string pagetable, int pageindex, int pagesize)
{

SqlCommand mycmd = new SqlCommand("ok", conopen());
mycmd.CommandType = CommandType.StoredProcedure;
SqlParameter workParm;
workParm = mycmd.Parameters.Add("@pagetable", SqlDbType.NVarChar, 50);
mycmd.Parameters["@pagetable"].Value = pagetable;

workParm = mycmd.Parameters.Add("@pageindex", SqlDbType.NVarChar, 50);
mycm