multiple values for webservice arguments.

Question

0.00/5 (No votes)

See more:

Hello everybody,
I'm currently writing a new web service and i'm a little bit stuck.

I'm trying to write a method that will filter results from a SQL database based on attributes passed to the web service :-

[WebMethod]
    public XmlDocument getSearchResults(string Attributes)
    {
        XmlDocument results = //get stuff from sql
        return results;
    }

Now, I need to be able to filter on multiple attributes at once (for example red AND round, or whatever, you get the idea) but the number won't always be the same, so I need to loop through and change the sql command accordingly to add each attribute. Is this possible? do I just added multiple elements of the same type to the SOAP envelope? if so how do I process them? :confused::~

Thanks in advance.
Gib

Posted 15-Oct-10 3:26am

Gibb3h

Updated 15-Oct-10 3:28am

Abhinav S

v2

Add a Solution

1 solution

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)

Sherylee · Accepted Answer · 2010-10-15T03:47:00

This is gunna be tuff, if u have the column names on the end thats calling the webservice your fine, but if not then thats gonna suck..

if you have the names you can basically make an array list on the Aspx side -

using system.collections()
   public XmlDocument callwebsvc()
     {
             arraylist arr = new arraylist();
             arr.add("columnName = '"+ textbox1.Text +"', columnTwoName = '" + textbox2.Text + "'");//or you could add them seperatly
             svc = new webserviceref.service();
             svc.QueryDB(arr.ToArray());
     }

so when your back at your web service you have a nice little array to work with..

 [webmethod]
public querydb(string[] arr){
    string sqlcommand = "select blabla from blabla"
    string where = "";
    for(i = 0; i < arr.length; arr++)
              where = t[i].tostring();
        }
    sqlcommand = sqlcommand + " where " + where;
//so your sqlcommand will be:
//select * from blabla where columnName = 'val1', columnTwoName = 'val2'
}

see what i mean? i did it before its handy enuf, just tricky