标题 点击数 回帖数 作者
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
sazxcxz 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafxxzczcsaf 123 33 fsdfsdfs
safdzxczxsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsaxzzxfas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
asfsafas 3 5 aaaaaa
sfafsafxzc 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfzczxcsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfazxczxfsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafxzcsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdcxzzxsfsa 3 32 aaaaaa
asfsafazcxs 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs 1 2 我做的这个不起作用,谁来帮帮我
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
sazxcxz 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafxxzczcsaf 123 33 fsdfsdfs
safdzxczxsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsaxzzxfas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
asfsafas 3 5 aaaaaa
sfafsafxzc 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfzczxcsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfazxczxfsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafxzcsaf 123 33 fsdfsdfs
safdsfsa 3 32 aaaaaa
asfsafas 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs
safdcxzzxsfsa 3 32 aaaaaa
asfsafazcxs 3 5 aaaaaa
sfafsaf 123 33 fsdfsdfs 1 2 我做的这个不起作用,谁来帮帮我
如果不用绑定控件的话,可以用js+xml分页。
用绑定控件,可以用repeater和linkbutton
(
@customerNumber VARCHAR(15),
@SortField VARCHAR(20) = 'orderId',
@SortType VARCHAR(10) = 'DESC',
@PageSize INT = 10,
@PageIndex INT = 0,
@TotalCount INT OUTPUT
)
AS
BEGIN
SELECT @TotalCount = count(orderId) FROM orders
WHERE customerNumber = @customerNumber
SET @sqlSelect = 'SELECT orderId FROM ('
SET @sqlSelect= @sqlSelect + 'SELECT ROW_NUMBER() OVER(ORDER BY ' + @SortField + ' ' + @SortType + ') AS rowNumber'
SET @sqlSelect= @sqlSelect + ', orderId'
SET @sqlSelect= @sqlSelect + ' FROM orders '
SET @sqlSelect= @sqlSelect + ') AS PagingTable '
SET @sqlSelect = @sqlSelect + ' WHERE rowNumber >=' + CONVERT(VARCHAR, @PageSize * @PageIndex)
SET @sqlSelect = @sqlSelect + ' AND rowNumber <' + CONVERT(VARCHAR, @PageSize * (@PageIndex + 1))
EXEC(@sqlSelect)ENDGO
http://topic.csdn.net/u/20090729/12/d80e8c3f-3bbe-4e0f-ad60-a11c3854d2ef.html?85226