How can we convert XML Data to DataBase Table in C#.Net?
Answers were Sorted based on User's Feedback
Answer / babar shaik
using System.XML;
We can fill the Dataset using
Ds.ReadXML();
Then Update the Data into Database.
| Is This Answer Correct ? | 13 Yes | 5 No |
Answer / 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 |
What is an example of a delegate?
Explain the serialization in .net
What is JIT (just in time)? how it works?
Explain the difference between a struct and a class?
What are strong name assemblies?
What is tpl in c#?
How can we insert 100 records @ a time without using for loop into the databse
How to assign default value to nullable types? Did nested nullable types are allowed
What is class in oops with example in c#?
Practcle scenario where I can use abstract class and where I can use Interface
1 Answers Jeevan Technologies,
may we achieve polyphormsm through overloading a funtion?Is it right or wrong concept because i read polyphormism can be achieved through overloading?plz help me thnks
HOW to Develope the CRUD(create,read,update,delete) FORM IN WINDOWS form by using c# only
0 Answers Petranics Solutions,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)