retrieve data from xml to database

Hi,
Please see following link for get data from two tables and insert in new datatable. It might be get hint from this link. 

http://stepbystepdotnet.wordpress.com/2012/09/13/how-to-join-two-data-tables-in-c-without-using-loop-in-linq/

http://www.c-sharpcorner.com/uploadfile/4d56e1/how-to-create-a-datatable-and-add-it-to-a-dataset/

http://www.c-sharpcorner.com/UploadFile/mahesh/ImportRow07092006195427PM/ImportRow.aspx

You can use DataTable and read your xml file to this datatable by DataTable.ReadXml() method.

Same you can add second xml file data to same or new datatable and merge both DataTable rows.

and using SQLBulkCopy you can insert DataTable data to SQL Server. Below article will give you required steps for SQLBulkCopy

 http://dotnetmentors.com/c-sharp/bulk-upload-into-sql-server-using-sqlbulkcopy-and-c-sharp.aspx