access element in an XML document

Question

access element in an XML document

lawrence 136

I will appreciate any urgent help please on how to access Element from an XLM document shown below to be used in the values tag.

My XML document generates both the attribute vs element as shown below.

My Problem is I don't know the right dataPath to access its element

  <PremiumComputation>\r\n    
    <RecordID>3</RecordID>\r\n    
    <TotalSumInsured>1136000000.00</TotalSumInsured>\r\n    
</PremiumComputation>

the above script gives error message :
Mapping XML user-defined value data attribute not found. value=TotalSumInsured, data=PremiumComputation/@TotalSumInsured

Again i tried
dataPath="TotalSumInsured"
dataPath="PremiumComputation/TotalSumInsured"

both gave the error message:
Object reference not set to an instance of an object.

What is the right way to access the path please.

Best regards

Lawrence

Yitzhak Khabinsky 27,196 Reputation points

2021-06-25T03:40:44.15+00:00

@lawrence ,

It is not clear what you are asking.
Please revise your question, and provide a minimal reproducible example.
Viorel 127K Reputation points

2021-06-25T13:19:42.853+00:00

The second dataPath seems appropriate. Which line or component gives "Object reference not set to an instance of an object"?

3 answers

Your answer

Yitzhak Khabinsky 27,196 Reputation points

2021-06-25T03:40:44.15+00:00

@lawrence ,

It is not clear what you are asking.
Please revise your question, and provide a minimal reproducible example.
Viorel 127K Reputation points

2021-06-25T13:19:42.853+00:00

The second dataPath seems appropriate. Which line or component gives "Object reference not set to an instance of an object"?

Answer 1

Do you mean to write something from code to xml?

Try something like this:

string filePath = @"C:\xxx\1.xml";  
            string xmlString = File.ReadAllText(filePath);  
            XDocument xdoc = XDocument.Parse(@xmlString);  
  
            var TotalSumInsured = xdoc.Descendants("values");  
            foreach (var item in TotalSumInsured)  
            {  
                foreach (var node in item.Nodes())  
                {  
                    if (node.NodeType == XmlNodeType.Element)  
                    {  
                        Console.WriteLine(((XElement)node).Attribute("dataPath").Value);  
                        ((XElement)node).SetAttributeValue("dataPath", "xxx");  
                        // or  
                        ((XElement)node).Attribute("dataPath").Value = "jjj";  
                    }   
                }  
            }  
            xdoc.Save(filePath);

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Timon Yang-MSFT 9,611 Reputation points

2021-07-05T09:00:24.37+00:00

@lawrence
May I know if you have got any chance to check my answer? I am glad to help if you have any other questions.

Answer 2

Yitzhak Khabinsky 27,196

Hi @lawrence ,

Please try the following solution.

c#

void Main()  
{  
	XDocument xdoc = XDocument.Parse(@"<PremiumComputation>  
	   <RecordID>3</RecordID>  
	   <TotalSumInsured>1136000000.00</TotalSumInsured>  
	</PremiumComputation>");  
  
	string TotalSumInsured = xdoc.Descendants("TotalSumInsured").FirstOrDefault().Value;  
  
	Console.WriteLine("TotalSumInsured: '{0}'", TotalSumInsured);  
}

Output

TotalSumInsured: '1136000000.00'

lawrence 136 Reputation points

2021-06-25T15:13:08.127+00:00

Thank you YitzhakKhabinsky.

The difference here is that we are working backward..."Code to XML".
while your solution example above is "XML to Code"

How can I adapt your solution code to "Code to XML" please?

Thank you so much.

Best regards.

Lawrence

Answer 3

Thank you for your prompt response YitzhakKhabinsky.

Here is my XML document root below:

<document dataPath="document/PolicySchedulePrintDTO">

<values>
            <value name="TotalSuminsured" 
            dataPath="PremiumComputation/@TotalSumInsured" binding="Static" required="true"/>
</values>
<predicates>
      <predicate name="IsTotalSuminsuredZero">
            <match when="TotalSuminsured" condition="gt" value="0"/>
       </predicate>
</predicates>

<generate layout="PolicySchedule"/>

</document>

Premium Computation Section

<body>
<section id="computation" dataPath="PremiumComputation">
     <table id="computationInformationTable">

 <columns>
      <column width="300"/>
       <column width="200"/>
         <column/>
 </columns>

 <rows>
  <row predicate="IsTotalSumInsuredZero" result="true">
   <cell leftBorder="yes" bottomBorder="yes" topBorder="yes" font="ThemeBold" rightBorder="yes" >
            <text align="Right"  fontSize="9" height="12">Total Sum Insured</text> 
     </cell>
      <cell  rightBorder="yes" topBorder="yes">
     <text dataPath="TotalSumInsured" font="ThemeBold" align="Left" type="Single" format="{0:#,##0.00}" height="8"/>
     </cell>
     </row>
 </rows>
</table>
</section>
</body>

The XML serialized result is stated below. I want to access the <TotalSumInsured> from the XML Serialized data shown below.

XML Serialized result <PremiumComputation>\r\nRecordID>3</RecordID>\r\n<TotalSumInsured>1136000000.00</TotalSumInsure>\r\n </PremiumComputation>

looking at the serialized XML result above, it has both Attributes and elements.

How do I access the element <TotalSumInsured> from the XML Serialized result above.
I need TotalSumInsured to test for the content in the <Values> tag above and use the result in the <Predicates> tag to hide a row information on the PDF document under Premium Computation script above, when the TotalSuminsured condition is not greater than 0 as shown in the script section under <predicate>

My main problem is I don't how to access the path where the<TotalSumInsured> is located in the XML . Instead of generating the PDF, the system throws an error message below:

"Mapping XML user-defined value data attribute not found. value=TotalSumInsured, data=PremiumComputation/@TotalSumInsured"

Please what am I doing wrong in the path below:

dataPath="PremiumComputation/@TotalSumInsured" binding="Static" required="true"/>

I hope it is clear now.

Best regards,

Lawrence

Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2021-06-25T09:03:02.38+00:00

This is still quite confusing. I see that you have tagged this with both sql-server-general and dotnet-csharp. I'm reading this from the SQL Server side, but it is not clear to me if you are trying extract the values in T-SQL or in C#. So I think could a start could be if you could tell us if which language you want help with.
lawrence 136 Reputation points

2021-06-25T10:19:55.57+00:00

Thank you ErlandSommarskog.
I am so sorry I did not mentioned the Language .

I am looking for help on C# please.

I want to generate report from a Model into PDF but first pass it through the XML to serialized the data and filter off rows that did not match a set values condition at the document root in the XML document.

My problem is how to access the XML document path to get the TotalSumInsured to be used to set the filter condition.

dataPath="PremiumComputation/@TotalSumInsured" binding="Static" required="true"/>

"Mapping XML user-defined value data attribute not found. value=TotalSumInsured, data=PremiumComputation/@TotalSumInsured"

Thank you in anticipation of your quick response.

Best regards

Lawrence

Share via

access element in an XML document

3 answers

Your answer