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.

Vinay Singh · Answer

Hi Check the code SqlCommandcmd= new SqlCommand( YourCommand  new SqlConnection( ConnectionString )); DataTabledt= new DataTable(); new SqlDataAdapter(cmd).Fill(dt); dt.TableName= YourTableName ; dt.WriteXml( FileAddress ); dt.WriteXmlSchema( SchemaFileAddress ); check the link http://www.c-sharpcorner.com/blogs/generating-xml-file-from-sql-database-using-c-sharp1 http://csharp.net-informations.com/xml/xml-from-sql.htm http://stackoverflow.com/questions/16768263/generate-xml-using-c-sharp-from-sql-server-data