Getting attributes from XML using c#

Question

I have the following xml contents inside a string variable. i want to get the value of each attribute (JID) in the form of string.

Below is my xml

  <query xmlns="http://jabber.org/protocol/muc#admin">
  <item affiliation="member" jid="a@something.com" />
  <item affiliation="member" jid="b@something.com" />
  <item affiliation="member" jid="c@something.com" />
  <item affiliation="member" jid="d@something.com" />
  <item affiliation="member" jid="e@something.com" />
  <item affiliation="member" jid="f@something.com" />
  <item affiliation="member" jid="g@something.com" />
  <item affiliation="member" jid="h@something.com" />
  <item affiliation="member" jid="i@something.com" />
  <item affiliation="member" jid="j@something.com" />
  </query>

Anyone please suggest some ideas to find this. my expected output is like

   a@something.com
   b@something.com
   c@something.com
   d@something.com
   e@something.com
   f@something.com

Cody Popham · Answer 1 · 2017-12-07T06:29:23.423

1

Linq to XML is one way to tackle it. Where the "" inside .Parse is - place the string variable with the xml.

           List<XAttribute> jids = XDocument.Parse("").Root.Elements().Attributes().ToList();
            foreach (XAttribute a in jids)
            {
              if (a.Name =="jid") 
              {
                string jid = a.Value;
              }
            }

edited Dec 07 '17 at 06:29

answered Dec 07 '17 at 06:20

Cody Popham

992
5
14

1

If you have saved the XML as "file.xml", use `XDocument.Load(PathToFile + "file.xml")` – Sebastian Hofmann Dec 07 '17 at 06:25
@Cody Popham Perfect Answer! This is what im looking for. – Lazy Programer Dec 07 '17 at 06:29
Yep! Don't forget to mark the questions as answered. Helps the community. – Cody Popham Dec 07 '17 at 06:30

score 0 · Answer 2 · answered Dec 07 '17 at 06:17

0

DataSet dsXml = new DataSet();
dsXml.ReadXmlSchema(Server.MapPath("~/Temp") + "//" + FileName);
dsXml.ReadXml(Server.MapPath("~/Temp") + "//" + FileName, XmlReadMode.InferTypedSchema);
 if (!string.IsNullOrEmpty(dsXml.GetXml()))
{
  for (int i = 0; i < dsXml.Tables.Count; i++)
            {

lblInfo.Text = lblInfo.Text + dsXml.Tables["item"].Rows[i]["jid"].ToString()
           }
}

answered Dec 07 '17 at 06:17

krunal shah

51
1
9

I am not reading the xml from .xml File, i just read the xml content which is inside a string variable like `string xmlQuery=" ";` – Lazy Programer Dec 07 '17 at 06:20

score 0 · Answer 3 · answered Dec 07 '17 at 06:39

try this

  var data = @" <query xmlns=""http://jabber.org/protocol/muc#admin"">
  <item affiliation=""member"" jid=""a@something.com"" />
  <item affiliation=""member"" jid=""b@something.com"" />
  <item affiliation=""member"" jid=""c@something.com"" />
  <item affiliation=""member"" jid=""d@something.com"" />
  <item affiliation=""member"" jid=""e@something.com"" />
  <item affiliation=""member"" jid=""f@something.com"" />
  <item affiliation=""member"" jid=""g@something.com"" />
  <item affiliation=""member"" jid=""h@something.com"" />
  <item affiliation=""member"" jid=""i@something.com"" />
  <item affiliation=""member"" jid=""j@something.com"" />
  </query>";
            var xml = XElement.Parse(data);
            var r = xml.Elements();
            var result = r.Select(item => item.Attribute("jid")?.Value).ToArray();

score 0 · Accepted Answer · answered Dec 07 '17 at 07:46

To achieve the required output you can use XMLDocument , XMLNode and XMLNodeList as follows

string sb = "<query xmlns=\"http://jabber.org/protocol/muc#admin\">" +
                         "  <item affiliation=\"member\" jid=\"a@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"b@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"c@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"d@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"e@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"f@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"g@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"h@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"i@something.com\" />" +
                         "  <item affiliation=\"member\" jid=\"j@something.com\" />" +
                         "  </query>";

            XmlDocument doc = new XmlDocument();
            doc.LoadXml(sb);

            XmlNodeList allXmlNode = doc.GetElementsByTagName("item");
            if (allXmlNode.Count >= 1)
            {
                foreach (XmlNode node in allXmlNode)
                {
                    System.Console.WriteLine(node.Attributes[1].InnerText);
                }
            }

Getting attributes from XML using c#

4 Answers4