Add dataset/datatable to XML Nodes RSS

• • Reply
  

  remyaviswan

  Member

  58 Points

  78 Posts

  Add dataset/datatable to XML Nodes

  Jan 29, 2013 10:41 AM|LINK

  Hy,

  I have an XML file and I want to fetch specific nodes from the file and to iterate them and append dataset/datatable as child nodes to those node.

  Plz help me

• • Reply
  

  Raigad

  Contributor

  5129 Points

  956 Posts

  Re: Add dataset/datatable to XML Nodes

  Jan 29, 2013 10:46 AM|LINK

  Refer this one

  http://babasahebkale.blogspot.in/2012/11/insert-edit-update-delete-in-xml-file.html

  Babasaheb Kale
  Mark as Answer, if the post helped you...
  Visit My Blog
  
• • Reply
  

  remyaviswan

  Member

  58 Points

  78 Posts

  Re: Add dataset/datatable to XML Nodes

  Jan 29, 2013 12:22 PM|LINK

  Thanks..but my issue is not like that.. Take a look on my XML;

  <?xml version="1.0" standalone="yes"?>
  <Claim.Submission>
    <Header>
      <SenderID>DHA123</SenderID>
      <ReceiverID>A002</ReceiverID>
      <TransactionDate>2012-07-05T15:00:00+05:30</TransactionDate>
      <RecordCount>3</RecordCount>
      <DispositionFlag>PRODUCTION</DispositionFlag>
    </Header>
    <Claim>
      <ID>123</ID>
      <MemberID>m01254</MemberID>
      <PayerID>A002</PayerID>
      <ProviderID>DHA123</ProviderID>
      <EmiratesIDNumber>111-1111-1111111-1</EmiratesIDNumber>
      <Gross>100</Gross>
      <PatientShare>0</PatientShare>
      <Net>100</Net>
      <Encounter>
        <FacilityID>DHA123</FacilityID>
        <Type>1</Type>
        <PatientID>1245</PatientID>
        <Start>01/01/2012 12:00</Start>
        <End>01/01/2012 15:00</End>
        <StartType>3</StartType>
        <EndType>2</EndType>
      </Encounter>
      <Diagnosis>
        <Type>Principal</Type>
        <Code>E11.9</Code>
      </Diagnosis>
      <Activity>
        <ID>1</ID>
        <Start>01/01/2012 13:00</Start>
        <Type>3</Type>
        <Code>83036</Code>
        <Quantity>1</Quantity>
        <Net>49</Net>
        <Clinician>DHA1234DHC</Clinician>
        <Observation>
          <Type>LOINC</Type>
          <Code>43150-2</Code>
          <Value>5</Value>
          <ValueType>%</ValueType>
        </Observation>
      </Activity>
    </Claim>
    <Claim>
      <ID>1234</ID>
      <MemberID>m01254</MemberID>
      <PayerID>A002</PayerID>
      <ProviderID>DHA123</ProviderID>
      <EmiratesIDNumber>111-1111-1111111-1</EmiratesIDNumber>
      <Gross>400</Gross>
      <PatientShare>155</PatientShare>
      <Net>245</Net>
    </Claim>
  </Claim.Submission>

  Here the node with name Claim is a childnode and I want to insert nodes like Encounter,Activity etc to Claim.
  
  

• • Reply
  

  remyaviswan

  Member

  58 Points

  78 Posts

  Re: Add dataset/datatable to XML Nodes

  Jan 30, 2013 04:30 AM|LINK

  Anybody plz tell me how to bind a datatable/dataset to an XElement. I have one XElement in my hand, I want to add childnodes. 

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Add dataset/datatable to XML Nodes

  Jan 31, 2013 12:11 AM|LINK

  remyaviswan

  I want to insert nodes like Encounter,Activity etc to Claim.

  Hi,

  Where do you wanna insert? Directly into xml?

  Please point out where you wanna insert?