Data insert xml to sqlserver

To add to previous answers, here's one starting point in MSDN: http://msdn.microsoft.com/en-us/library/ms189887.aspx[^]

Use following code to retrieve data from XML File and transfer to sql:

 try
            {
                XmlReader xmlFile;
                xmlFile = XmlReader.Create("Product.xml", new XmlReaderSettings());
                DataSet ds = new DataSet();
                ds.ReadXml(xmlFile);
// Here you can insert your code to save your dataset contents to Sql Server easily.

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            } 

Hope this will help you.

Fetch data from XML using LINQ
or Read XML using DATASET or DATATABLE [datasetObj.ReadXML() or datatableObj.ReadXML()].

Iterate through Record you have acquired and insert it into your desired table.
Hope it will help you......

SQL does have a very good XML support. Read about it on MSDN and give it a try. Do not hesitate to post a specific question if you are not able to work your way through it.

to db: http://quickduck.com/blog/2008/02/18/persisting-objects-into-database-using-xml-serialization/[^]

from db: http://quickduck.com/blog/2008/02/15/using-xmlreader-to-go-from-sql-result-set-to-a-list-of-objects/[^]