使用Web服务检索记录 [英] retrieving records using webservice

问题描述

我使用一个从数据库检索数据的Web服务.对于某些搜索条件，它检索了200多个记录.

我的查询是
1)我一次只能检索150条记录.
2)当用户单击下一步时，接下来的150条记录必须在网格视图中显示.

我也不想一次检索所有记录(这可能吗?)

知道如何实现相同的方法吗?

在此先谢谢您..

I use a webservice which retrieve data from database.For some search criteria,it retrieves more than 200 records.

My query is
1) i want to retrieve only 150 records at a time.
2)when the user clicks next,The next 150 records have to be displayed in grid view.

also I dont want to retrieve all the records at once(Is this possible?)

Any idea how to implement the same?

Thanks in advance..

推荐答案

请参阅此 [ ^ ]文章.可能会有帮助.

See this[^] article on paging. It may help.

您已经拥有什么代码?您是否已将存储的过程写入数据库中?您是否编写了调用数据库中存储的proc的Web服务?您是否编写了调用Web服务的客户端应用程序，该Web服务调用了数据库中存储的proc?

我感觉像苏斯博士...

What code do you already have? Have you written your stored procs in the database? Have you written the web service that calls the stored procs in the database? Have you written the client app that calls the web service that calls the stored procs in the database?

I feel like Dr. Seuss...

WITH temp AS
(
Select Row_Number()  OVER(Order By Customer_Account_Code) as RowThing , * FROM CUSTOMER_ACCOUNT  
)
Select * FROM temp WHERE RowThing BETWEEN 50 AND 60

您将不得不以不同的方式使用数据库.

但这似乎可行.

You will have to work it differently with your DataBase.

But that seems to work.

这篇关于使用Web服务检索记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！