How to save xml data from an XmlDocument object into a SQL table using C#



my XML is as below



<employees> <employee email="email1" dateofbirth="1900-01-01" lastname="lastname1" firstname="firstname1" /> <employee email="email2" dateofbirth="0001-01-01" lastname="lastname2" middleinitial="2" firstname="firstname2" /> </employees>


And my table [dbo.Employee] in the DB has the columns below



  • FirstName

  • LastName

  • DOB


The above XML data is available to me in an XmlDocument object. I would like to save the above data in the respective columns in the SQL table. Please help..


No comments:

Post a Comment