Solved

XML data into comma seperated string

Posted on 2009-04-08
5
297 Views
Last Modified: 2012-05-06
I call a web service and get following XML (see code).

I need to know how do I convert the data into:

7369, 8834

In other words, If I get results, I need to convert result into comma separated string so that I can pass it to query string in URL



- <NewDataSet>
- <Table>
  <ext_user_id>7369</ext_user_id> 
  </Table>
- <Table>
  <ext_user_id>8834</ext_user_id> 
  </Table>
  </NewDataSet>

Open in new window

0
Comment
Question by:immtrac
  • 3
  • 2
5 Comments
 
LVL 23

Accepted Solution

by:
apresto earned 125 total points
ID: 24098668
Something like this?
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
        doc.LoadXml("<NewDataSet><Table><ext_user_id>7369</ext_user_id></Table><Table><ext_user_id>8834</ext_user_id></Table></NewDataSet>");
        System.Xml.XmlNodeList nodeList = doc.GetElementsByTagName("Table");
 
        string values = "";
 
        foreach (System.Xml.XmlNode tableNode in nodeList)
        {
            System.Xml.XmlNode numNode = tableNode.SelectSingleNode("ext_user_id");
            values = numNode.InnerText + ",";
        }
        values += values.Substring(0, values.Length - 1);

Open in new window

0
 

Author Comment

by:immtrac
ID: 24098731
Thanks for your reply. When I call web service  I don't know if I get 10 ids, 100 ids or nothing.

So I can not  hard code the XML.

Also is there way that we can use split() function?
0
 
LVL 23

Expert Comment

by:apresto
ID: 24098933
I was only hardcoding the xml for demonstration purposes, all you need to do is put the string returned by the webservice into it. This method will work for 10 or 100 nodes in an xml string.
Why would you want to use split, the XmlDocument class is there for a reason, lol
0
 

Author Comment

by:immtrac
ID: 24100500
What I am getting is 8834,8834

While is should be 7369,8834.
0
 

Author Comment

by:immtrac
ID: 24100818
Never mind. I got it.

Thanks for ur help
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

832 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