How can we convert XML Data to DataBase Table in C#.Net?
Answer Posted / arindamrudra
If the XML Document comes like this
@XmlDocument ='<PARAMS><STATIC><INTERVIEWDATETIME>2/13/2009</INTERVIEWDATETIME></STATIC></PARAMS>'
We will have to write
EXEC sp_xml_preparedocument @docHandle OUTPUT, @XmlDocument
@docHandle and @XmlDocument are variable of datatype int and XML respectively.
then we have to use the similar type of code to get the value from XML and the variables should be taken on the basis of the datatype coming from the XML.
DECLARE @date1 DATETIME
SELECT
@date1=Date11
FROM OPENXML(@docHandle, 'PARAMS/STATIC', 1)
WITH
(Date11 DATETIME 'INTERVIEWDATETIME')
EXEC sp_xml_removedocument @docHandle
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Does c# have a 'throws' clause?
Can a struct inherit from an interface in c#?
Difference between call by value and call by reference in C#?
Should I use double or float?
How do you escape c#?
What is the difference between new and override in c#?
Tell us something about static linking and dynamic linking?
What is access specifier in c#?
Is php better than c#?
What is difference between method and function in c#?
What method is used to sort the elements of the array in descending order?
Is array ienumerable c#?
Does c# support multilevel inheritance?
Which framework is best for desktop application?
What is the adv of using System.Text.StringBuilder over System.String?