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

Differentiate between object pooling and connection pooling in c#?

0 Answers  

---

List some of the basic string operation?

0 Answers  

---

can we access main() using objects?

1 Answers   ssinformatics,

---

What is a HashCode?

1 Answers  

---

how to Create a datagridview control with check box column with 8rows in it, the maximum number of check boxes checked should be 3, when user checks the 4th corresponding message should be displayed and check box should be checked. User can uncheck the checked boxes Note: read-only property should not be used

0 Answers   HCL, NIC,

---

What are properties and indexer?

1 Answers   TCS,

---

Expalin the way you implement inheritance by using VB.NET/C#?

0 Answers   Siebel,

---

What is addressof operator?

0 Answers  

---

What is the use of getcommandlineargs() method in c#.net?

0 Answers  

---

What?s the difference between <c> and <code> XML documentation tag?

1 Answers  

---

What are strong name assemblies?

0 Answers   CitiusTech,

---

OOPs concept ?

1 Answers   iGate, MMTS,

---