how to read data from xmland insert in sql in the corresponding columns by using storedprocedure

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi,
i want to read an xml file through xmldocument in c#.net and insert it in sql table in the corresponding columns of the table by using storedprocedure.suppose if i have 3 columns in a table and i created a storeprocedure of inserting the three columns.but
i am having five elements in my xml file .how to read that xml file and insert the corresponding three columns only in my table

View the full article
 
Back
Top