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 are Regex / regular expressions ?

0 Answers   QuestPond,

---

Should I use double or float?

0 Answers  

---

what is the purpose of Interfaces?

7 Answers   HCL,

---

What is data annotation in c#?

0 Answers  

---

What do you mean by saying a "class is a reference type"?

0 Answers  

---

What is tochararray in c#?

0 Answers  

---

What is a deadlock lock?

0 Answers  

---

Why do we need structs in c#?

0 Answers  

---

Define parsing?

0 Answers  

---

What does mean before a string in c#?

0 Answers  

---

is it possible to inherit a class but methods declared in the class should not be inheritable i possible how?

8 Answers   Microsoft,

---

Does C# support multiple inheritance?

3 Answers   IBM, Siebel Systems, Visual Soft,

---