Data insert xml to sqlserver

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......

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

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/[^]

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.

<pre lang="text"><pre lang="HTML"><pre lang="CSS"><pre lang="Javascript"><pre lang="SQL"><pre lang="SQL"><pre lang="PHP"><pre lang="PHP"><pre lang="PHP"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><small><small><small><a href=""></a>[<a href="" target="_blank"></a>]</small></small></small>