Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can we convert XML Data to DataBase Table in C#.Net?

Answers were Sorted based on User's Feedback



How can we convert XML Data to DataBase Table in C#.Net?..

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

How can we convert XML Data to DataBase Table in C#.Net?..

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

Post New Answer

More C Sharp Interview Questions

What is an example of a delegate?

0 Answers  


Explain the serialization in .net

0 Answers  


What is JIT (just in time)? how it works?

0 Answers  


Explain the difference between a struct and a class?

0 Answers  


What are strong name assemblies?

0 Answers   CitiusTech,


What is tpl in c#?

0 Answers  


How can we insert 100 records @ a time without using for loop into the databse

10 Answers   IBM,


How to assign default value to nullable types? Did nested nullable types are allowed

2 Answers   TCS,


What is class in oops with example in c#?

0 Answers  


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

1 Answers  


HOW to Develope the CRUD(create,read,update,delete) FORM IN WINDOWS form by using c# only

0 Answers   Petranics Solutions,


Categories