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);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
Hope this will help you.