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 multiple interface in c#?

0 Answers  

---

Is post back in c#?

0 Answers  

---

What are the advantages of properties in c#?

0 Answers  

---

Is array ienumerable c#?

0 Answers  

---

What is serialization in dot net?

0 Answers  

---

What is the difference between function and method in c#?

0 Answers  

---

What is uint c#?

0 Answers  

---

Can we have a non static member function in a base class to be override in derived with static modifier?

7 Answers   Wipro,

---

If u declare two interfaces withsame methodnmae .prototype how can u call the particular method from class?

4 Answers   Microsoft,

---

How do you prevent a class from being inherited?

0 Answers  

---

Can you declare struct members as protected?

0 Answers  

---

Explain the steps to create satellite assembly?

0 Answers  

---