Update selective nodes values of pre-defined XML

[shubhamkumar.tiwari (Shubham Tiwari)]

Sample XML:

<SampleXML formID="SDF" formType="R" ID1="12" ID2="999abc" endDate="2018-01-01T00:00:00" Seq="1" ID3="" Name="" Title="" Email="" Date="2018-01-01T00:00:00" xsi:noNamespaceSchemaLocation="Schemas/RDF.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <123>
    <value>Shubham</value>
    <statement>Questions</statement>
  </123>
  <456>
    <value>studio</value>
    <statement>Questions</statement>
  </456>
  <789>
   <value>Tiwari</value>
   <statement>Questions</statement>
  </789>
</SampleXML>

@ppr : I referred your solution in following article:

I want to update the xml attriute values in xml and values should come form excel file

@tejach412 As the elements, which are to update, are unique, so the flow is less complex Base Pattern is like this (not showing explicitly read in excel, parsing XML) [grafik] iterating over each row selecting XML Element updating XML Element finally save XML Document I show cased this for you with two approaches: LINQ to XML API: xDoc.Descendants(row(“ElementName”).ToString.Trim).Single XPATH Statement: xDoc.XPathSelectElements(row(“ElementName”).ToString.Trim).Single So decide by yo…

but after a point where it reaches ,<456> for which there is no value input from datatable as I don’t intent to update it but the next node <789> I get the error. Error: Assign xDoc descendants: Sequence contains no elements. This error is coming in assign where we get descendants in variable.

Can you please suggest the solution(urgent), reason or updated logic to do this?

TIA,
Shubham