How to read xml attribute of following xml using linq? RSS

• • Reply
  

  info2ambrish

  Member

  385 Points

  275 Posts

  How to read xml attribute of following xml using linq?

  Apr 11, 2012 01:36 PM|LINK

  Hi All

  My Xml Is Following:

  <MyNode>
  
  <default>
  <FIELD NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </default>
  <WorkType ID="1">
  <FIELD NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </WorkType>
  <WorkType ID="2">
  <FIELD NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </WorkType>
  </MyNode>
  In above xml i want to read attributes like NAME,CONTROLTYPE etc of FIELD tag.
  if WorkType id=1 than read id 1 FIELD
  if WorkType id=2 than read id 2 FIELD
  if id not match than go to default section and read FIELD attributes.
  
  pls provide linq query code that full fill my requirmrnts.
  thanks in advance

  
  
  

• • Reply
  

  mm10

  Contributor

  6439 Points

  1184 Posts

  Re: How to read xml attribute of following xml using linq?

  Apr 11, 2012 01:42 PM|LINK

  I don't really understand what you want here, how many/what properties do you wish the return type to have?

  Please 'Mark as Answer' if this post helped you.
• • Reply
  

  info2ambrish

  Member

  385 Points

  275 Posts

  Re: How to read xml attribute of following xml using linq?

  Apr 11, 2012 01:51 PM|LINK

  mm10

  <MyNode>
  
  <default>
  <FIELD3 NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </default>
  <WorkType ID="1">
  <FIELD1 NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </WorkType>
  <WorkType ID="2">
  <FIELD2 NAME="AAID" CONTROLTYPE="TextBox" DBFIELD="AA"/>
  </WorkType>
  </MyNode>

  in my xml

  i want conditional linq uery

  like

  if(work type attribute ID==1)

  get the attributes value of FIELD1 tag.

  else if(work type attribute ID==2)

  get the attributes value of FIELD2 tag.

  else

  {

  in default tag read 

  get the attributes value of FIELD1 tag.

  }

  pls provide linq query

  • Edited by info2ambrish on Apr 11, 2012 01:54 PM
• • Reply
  

  Ramesh T

  Contributor

  5121 Points

  827 Posts

  Re: How to read xml attribute of following xml using linq?

  Apr 11, 2012 02:08 PM|LINK

  Try something like this

  XDocument xDocument = XDocument.Load(@"Ur Xml File Path");
  
  var items = from x in xDocument.Descendants("WorkType")
              where x.Attribute("ID").Value == "Ur WorkType Id"
              select x;
  
  if (items.Count() > 0)
  {
      var attributes = (from field in items
                          select new
                          {
                              NAME = field.Attribute("NAME").Value,
                              CONTROLTYPE = field.Attribute("CONTROLTYPE").Value,
                              DBFIELD = field.Attribute("DBFIELD").Value
                          }).First();
                      
  }
  else
  {
      var attributes = (from def in xDocument.Descendants("FIELD3")
                          select new
                          {
                              NAME = def.Attribute("NAME").Value,
                              CONTROLTYPE = def.Attribute("CONTROLTYPE").Value,
                              DBFIELD = def.Attribute("DBFIELD").Value
                          }).First();
  
  }

  
  
  

  • Edited by Ramesh T on Apr 11, 2012 02:08 PM
  • Edited by Ramesh T on Apr 11, 2012 02:09 PM
  • Edited by Ramesh T on Apr 11, 2012 02:15 PM
  • Edited by Ramesh T on Apr 11, 2012 02:16 PM
  • Marked as answer by info2ambrish on Apr 12, 2012 04:52 AM
• • Reply
  

  info2ambrish

  Member

  385 Points

  275 Posts

  Re: How to read xml attribute of following xml using linq?

  Apr 12, 2012 04:52 AM|LINK

  Ramesh T

  Try something like this

  XDocument xDocument = XDocument.Load(@"Ur Xml File Path");
  
  var items = from x in xDocument.Descendants("WorkType")
              where x.Attribute("ID").Value == "Ur WorkType Id"
              select x;
  
  if (items.Count() > 0)
  {
      var attributes = (from field in items
                          select new
                          {
                              NAME = field.Attribute("NAME").Value,
                              CONTROLTYPE = field.Attribute("CONTROLTYPE").Value,
                              DBFIELD = field.Attribute("DBFIELD").Value
                          }).First();
                     
  }
  else
  {
      var attributes = (from def in xDocument.Descendants("FIELD3")
                          select new
                          {
                              NAME = def.Attribute("NAME").Value,
                              CONTROLTYPE = def.Attribute("CONTROLTYPE").Value,
                              DBFIELD = def.Attribute("DBFIELD").Value
                          }).First();
  
  }

  
  

  Thanks lot 

  you save my life.Its working perfectly