存储过程分页

+@Id1+' and '+@Id2

)

end

GO

asp中使用方法:

<%

page = trim(request.QueryString(page))

if page= then

ipage = 1

else

ipage = cint(page)

end if

pagesize = 30

set rs = server.CreateObject(adodb.recordset)

sqlstr=select top 1000000 id,lovedress,chattoolnote,email from [5years_vote] order by id desc

sqlstr1=select count(1) from [5years_vote]

sql=p_show '&sqlstr&',&pagesize&,&ipage

'Response.Write sql

'Response.End

rs.Open sql, conn, 3,3

'Response.Write sqlstr

'Response.End

%>

c#:

public DataSet GetResumeListBox(int pagesize,int PageCurrent)

{

SqlDataAdapter sda=new SqlDataAdapter() ;

DataSet ds =new DataSet();

sda.SelectCommand = (new DataAccess.DbCFG()).GetCommand();

string sql=Select top +DbCFG.TopCount+ dbo.BaseInfo.*,dbo.ApplyJob.id as aid,jobinfo.jobname FROM dbo.ApplyJob RIGHT OUTER JOIN dbo.BaseInfo ON dbo.ApplyJob.rid = dbo.BaseInfo.id left join jobinfo on ApplyJob.jobid=jobinfo.id where dbo.ApplyJob.JobId in (+positionid+) and ApplyJob.ApplyState='0' and Iflow='0' ;