从Web Service加载前20个列表项，然后从android中的WebService获取后20个列表项 [英] Load first 20 list item from web service and then fetch next 20 from webservice in android

问题描述

大家好，

我正在使用.net Web服务将数据绑定到列表视图.但问题是，在一种情况下，我将有约1000条记录绑定到listview.这消耗大量时间.所以我想使用，获取20个项目，然后从Web服务中获取接下来的20个项目.我正在使用Ksoap库与Web服务进行通信.因此，任何人都有关于管理大量数据的想法.
高级谢谢........

Hi Everyone,

I am using .net web service for binding data to the list view . But the thing is i have around 1000 records to be binded to listview in one scenario. This is consuming lot of time. so i want to use,fetching 20 items then fetch next 20 items like this from web service. Am using Ksoap library to communicate with web service. So any one have an idea about management of large amount of data.
Advanced Thanks........

推荐答案

尝试在下面的sql server示例查询中进行分页


SELECT TOP(@PageSize)* FROM
(
SELECT RowID = ROW_NUMBER()OVER(ORDER BY CreatedDate DESC)，名称，年龄

从
(选择姓名，员工年龄
消息
)
在哪里A.RowID> ((@ Page-1)* @ PageSize)ORDER BY CreatedDate desc

Try to do paging at sql server sample query below


SELECT TOP(@PageSize) * FROM
(
SELECT RowID = ROW_NUMBER() OVER (ORDER BY CreatedDate DESC), Name, age

FROM
(select name, age from employees
)Msg
)
A WHERE A.RowID > ((@Page-1)*@PageSize) ORDER BY CreatedDate desc

这篇关于从Web Service加载前20个列表项，然后从android中的WebService获取后20个列表项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！