retrieving records using webservice

Question

1.00/5 (3 votes)

See more:

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..

Posted 12-May-11 2:37am

bsb25

Add a Solution

3 solutions

Solution 1

SQL

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.

Posted 12-May-11 2:41am

Rob Branaghan

Updated 12-May-11 3:19am

v3

Comments

bsb25 12-May-11 8:43am

am using sql 2005 server

Rob Branaghan 12-May-11 9:23am

Try that now

Rob Branaghan 12-May-11 9:30am

bsb25 Check my solution, if you add this to your stored procedure / function, you can set the 50 and 60 to be two parameters. so you could say select where rowthing between x and y.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-05-12T03:28:00

Solution 3

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

Posted 12-May-11 3:28am

Abhinav S

Comments

bsb25 12-May-11 9:31am

thank u dude.....this is what i wanted.

fjdiewornncalwe 12-May-11 10:01am

Please Accept Abhinav's answer if it was helpful.

Abhinav S 12-May-11 10:23am

Thanks Marcus. Very good point. :)

#realJSOP · Accepted Answer · 2011-05-12T02:45:00

Solution 2

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...

Posted 12-May-11 2:45am

#realJSOP

Comments

bsb25 12-May-11 8:48am

currently my webservice retrieves records from the respective tables.the client app is also been done...

#realJSOP 12-May-11 8:49am

I'm not going to continue trying to help until you remove the 1 vote.

bsb25 12-May-11 8:53am

sorry,you really pissed me off,with that comment of yours...

#realJSOP 12-May-11 9:02am

With what comment? Have you ever read a Dr. Seuss book?

bsb25 12-May-11 9:04am

yes i have read the book..no one is perfect,Bro...everyone is here to learn something.If you know the answer plz share it..otherwize dont....

#realJSOP 12-May-11 9:19am

Well, "bro", if you weren't trying so hard to cop an attitude, you'd relaize that you failed to provide enough info as to what you had done, much less what you actually needed. How can anyone help you if you haven't given us the info we need to provide an ACCURATE response?

bsb25 12-May-11 9:27am

Bro,If u read my question again,I have clearly mentioned that i am using a webservice to retrieve data.Also i have mentioned that it will be displayed in gridview.So it's clear what i have done...If it was not enough info...i dont know wat to do.....

Just deleting the question wud be a good idea i guess.