Guiqiu call the stored procedure code!

ddddd_00

ALTER PROCEDURE [dbo]. [PageList]
(
    @PageSize int,-records per page
    @PageIndex int,-the current number of pages, starting at 1
    @Condition varchar (8000),-query conditions, including and, where, must have a condition such as where 2> 1
    @TheTable varchar (8000), --table name
    @SelectField varchar (8000),-the field to be selected
    @OrderBy varchar (8000), --OrderBy, including order
    @TableID varchar (8000) --table primary key
)
AS
begin
declare @Sql varchar (8000)
 
--Return record
set @ Sql = 'select top' + cast (@PageSize as varchar (10)) + '' + @SelectField + 'from' + @TheTable + '' + @Condition + 'and'
    + @TableID + 'not in (select top' + cast ((@ PageSize * (@ PageIndex-1)) as varchar (10)) + '' + @ TableID + 'from' + @TheTable + '' + @Condition
    + '' + @OrderBy + ')' + @OrderBy
exec (@sql)
 
--- return total
set @ Sql = 'select count (' + @TableID + ') from' + @TheTable + '' + @Condition
exec (@sql)
end
Call this stored procedure, and return the recordset and number of records! Weep! !! !! !! !! !! 1

herroyuy46

You can get the number of records in the program. If the dataset is returned, the number of records is dataset.Tables [0] .Rows.Count

litblue

I am foolish. Don't know what exactly is the return record you are talking about?

Return Total: select @@ rowcount
exec [dbo]. [PageList] Parameter 1, Parameter 2, Parameter 3, ...

hanzos

OUTPUT parameter

lin3412048

SqlCommand cmd = new ...;
cmd.CommandType = SqlCommandType.sProc // The stored procedure can't remember
cmd.Parameters.Add ("@ PageSize", SqlDbType.Integer);
cmd.Parameters [0] = PageSize;

qwer000

As far as the stored procedures above you are concerned,
dataset.tables [0] is the record of the current page you want
dataset.Tables [1] .rows [0] [0] is your total number of records

qwer000

PS: TOP does not seem to be able to handle multi-primary key paging, it is recommended that the landlord use the temporary table paging method