XML to SQL Server data extraction

Question

Dear C# CORNER Team,

I want to thank you all for the support you have rendered to me so far, but i have the following challenge with my recent C# project.

the challenge is as follows

1 my client want us to extract data's from their database using their existing XML script format which is attached.

2 we are able to generate sql scripts to extract the data from the database the Challenge is populating the XML file to reflect their XML format.

Along with this question we atteched both our trier sample code file in asp.net C# (frmNDRExtractCombine.aspx.cs ) and the XML File (COMPLETE.xml ) in a zip file

we want to thank you in advance hoping to get quick solution from you.