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