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

Why do we use virtual methods in c#?

0 Answers  

---

What is string concatenation?

0 Answers  

---

Hi, Can we implement the Abstract class on interface in c#, If yes then provide the code implementation

1 Answers   RHR, Wipro,

---

Explain the difference between passing parameters by value and passing parameters by reference with an example?

0 Answers  

---

What are the benefits of using the aggregate method in linq?

0 Answers  

---

what is CLONE() method?

1 Answers  

---

Indexers in c#?

8 Answers   Intaglio, Microsoft, TCS,

---

What is the use of base keyword? Tell me a practical example for base keyword’s usage?

0 Answers  

---

What is whitespace in c#?

0 Answers  

---

Explain the difference between proc. Sent by val and by sub?

0 Answers  

---

What is yield break in c#?

0 Answers  

---

What is a clr (common language runtime)?

0 Answers  

---