dumping XML data to SQL Server

Question

Hi I have an XML file I need to dump the data in 4 different tables. Can any one please provide the C# code to achieve this. Regards MZEE

Virus Kiraak · Answer

I want to achieve it using SqlBulkCopy. And also I need to copy the data in 4 tables. How can I achieve it. Regards MZEE

Santhosh Kumar Jayaraman · Answer

Hi The below code will read xml and save it in datatable. You can use the same logic to save into database through entity framework or stored proc. //the path in which XML file is saved string path = D:\Santhosh\XMLFile1.xml ; DataSet ds= new DataSet(); //Reading XML file and copying to dataset ds.ReadXml(path); dataGridView1.DataSource = ds; dataGridView1.DataMember = table1 ; you can read more in the below article. http://www.c-sharpcorner.com/UploadFile/1a81c5/populating-values-from-xml-to-gridview-and-from-gridview-to/