Insert Data from XML File in SQL Server over Telerik Data Access

[Steve]

Hey i have  a important question. I added a Telerik Data Access to my project and have to read a XML File with data and import this into my database on sql server 2008 R2.

If i use a dataset i have a method ReadXML to retrieve the data out of the xml file. But since im using Telerik Data Access i wanna know if there is also a option to insert data from the xml file into the database.

Any help would be very appreciated thanks

[Ralph Waldenmaier]

Hello Steve,

I am not sure if I understood your question correctly.

In case you want to extract values from your xml, you of course can read the values using standard C# and create new persistent objects based on these values, which are then stored in the database.

At the moment there is no automation in Telerik Data Access to do this for you.



I hope this information is helpful for you.

Do come back in case you have any other questions.



Regards,

Ralph Waldenmaier
Telerik

[Steve]

thanks, and yes i did it with standard c#. I wanted to know as u have said if there is a way of automation to do this. But it all worked out fine.