how to find record count via web service in c#

Posted on 2012-08-28
Last Modified: 2012-09-12
From the webserivce if you enter integer values between 1-6000 in nGroupId field. we get a valid xml record but if we try an integer above 6000 i.e. 6001 or more we get invalid response like below

<errorMessage>No results found</errorMessage>

How can we possibly find the valid values for this field or record count
Question by:mmalik15
    LVL 20

    Expert Comment

    There has to be some database logic that goes into retrieving the results.

    This has nothing related to sending valid values. i.e more than a certain number(6000 in this case).

    If the no. of groups present in the Database is 6000, you will get an such a result when you enter a value more than 6000.

    Author Comment

    thanks for the comment.

    Are you saying that there is no way to find the record count from the client end before starting the loop to retrieve values?
    LVL 1

    Accepted Solution


    To my knowledge I don't believe you can do without having more access to their data. What I normally do in this situation is handle the returned error message in the code.

    If you wanted a list of all valid inputs you could quickly create a program to loop round 10000 times (example). Spawn alo request to the web service passing in the counter as the parameter and when you get the response, parse it for either GroupID or ErrorCode and depending on which you get pipe the results off to a certain cation  (DB, text file etc)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
    This video is a brief demonstration on how to use security groups and Network Access Control Lists (ACLs) in Amazon Web Services.  Security groups and Network ACLs are mechanisms you can use in AWS to control network traffic.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now