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!