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 escape sequences explain with example?

0 Answers  

---

What is difference between first and firstordefault?

0 Answers  

---

Explain how many types of exception handlers are there in .net?

0 Answers  

---

What is uint c#?

0 Answers  

---

We cannot create instances of static classes. Can we have constructors for static classes?

0 Answers  

---

What is difference between ilist and list?

0 Answers  

---

What are the collection types can be used in c#?

0 Answers  

---

Does c# have a 'throws' clause?

0 Answers  

---

When do we generally use destructors to release resources?

0 Answers  

---

If a base class has a bunch of overloaded constructors, and an inherited class has another bunch of overloaded constructors, can you enforce a call from an inherited constructor to an arbitrary base constructor?

1 Answers  

---

Name which controls do not have events?

0 Answers  

---

What is string concatenation?

0 Answers  

---