Answer / babar shaik

using System.XML;

We can fill the Dataset using

Ds.ReadXML();

Then Update the Data into Database.

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

What is cts, clr?

0 Answers  

---

What is default constructor in c#?

0 Answers  

---

Can you inherit multiple interfaces?

3 Answers  

---

What are lambda expressions used for?

1 Answers  

---

what is method overloading in c#?

0 Answers   Arigo Infotech,

---

What is the difference between dispose() and finalize() methods in c#?

0 Answers  

---

What is lastindexof c#?

0 Answers  

---

What is an interface class in c#?

0 Answers  

---

What are data types in C#?

0 Answers   TryTechnicals Pvt Ltd,

---

Explain the difference between and xml documentation tag?

0 Answers  

---

What does int32 mean?

0 Answers  

---

What is the meaning of MSIL?

0 Answers   TCS,

---