create procedure [dbo].[selectPage] @pageCount int output, @pageSize int,--每页有多少数据 @pageIndex int--第几页 as --从动态语句中获取返回值 declare @n nvarchar(100) set @n='select @pc = count(*) from TestTable' exec sp_executesql @n,N'@pc int output',@pagecount output declare @sql varchar(1000) set @sql='select top '+ltriM(@pageSize)+' ID,Name from TestTable where id not in (select top '+ltrim(@pageSize * (@pageIndex-1))+' id from TestTable)' exec(@sql) go
aspnetpager这个组件吧,用起来还算方便
连接mysql首先要安装mysql连接的驱动,然后引用MySql.Data,程序里面添加空间using MySql.Data.MySqlClient;查询数据库 返回DataSetMySqlConnection conn = new MySqlConnection(server=;user id=;pwd=;database=;); MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); DataSet ds = new DataSet(); da.Fill(ds); return ds;
create procedure [dbo].[selectPage]
@pageCount int output,
@pageSize int,--每页有多少数据
@pageIndex int--第几页
as
--从动态语句中获取返回值
declare @n nvarchar(100)
set @n='select @pc = count(*) from TestTable'
exec sp_executesql @n,N'@pc int output',@pagecount output declare @sql varchar(1000)
set @sql='select top '+ltriM(@pageSize)+' ID,Name from TestTable where id not in
(select top '+ltrim(@pageSize * (@pageIndex-1))+' id from TestTable)'
exec(@sql)
go
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;