How to convert an xml file to sql table by C# ?

[kakaleyte]

I have an Test.xml file. I need to convert it to sql table and save all data by C#.How can i do it ??

[Thats Aragon]

Hi You can convert the xml file into DataTable. From that you can easily save that data to the SQL table. Regards :)

[kakaleyte]

So, how can i save datatable to the sql table :) ? ?

[Thats Aragon]

May be this will help you. http://support.microsoft.com/kb/316005[^]

Regards :)

[kakaleyte]

thanks.. :)

[Cosby]

If i've a huge xml file and i want copy that data into sql server ce table. How can i do to store it faster?