Hi All,
I want to get child node value which is stored in database in xml format node is below like that.
<Main>
<field Dates="01/03/2022">
<structure dataType="DateTime" culture="en-GB" checkedValues="" />
<fn>dates</fn>
<fv id="date">2022-03-01</fv>
</field>
</Main>
so above is my sql server value in xml format and I want the value from FV node, but in xml no of FV node is present in XML. So please help me
thank in advance!