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

How do I edit a dll file?

0 Answers  

---

What is null in database?

0 Answers  

---

What is asp net c#?

0 Answers  

---

What is default value of bool in c#?

0 Answers  

---

Can you access a hidden base class method in the derived class?

0 Answers  

---

Can mvc be used for desktop applications?

0 Answers  

---

What debugging tools come with the .NET SDK? CorDBG

1 Answers  

---

i want o/p 011242110 in c# code.

0 Answers   TCS,

---

Explain the process of inheriting a class into another class?

0 Answers  

---

Is an interface a type c#?

0 Answers  

---

What’s thread.sleep() in threading ?

0 Answers  

---

Explain the three test cases in unit testing?

0 Answers   Siebel,

---