I have XML file with folowing structure and I want to populate the SHAPE,NAME and Date_Time elements with data from SqlServer. Can somebody show me the right way?
<?xml version="1.0"?>
<doc>
<msg>
<DatasetDefID>2 5562</DatasetDefID>
<SHAPE />
<NAME/>
<Date_Time />
</msg>
<msg>
<DatasetDefID>2 5562</DatasetDefID>...