You need to retrieve data from a Microsoft SQL Server 2000. Currently you are u

You need to retrieve data from a Microsoft SQL Server 2000.
Currently you are using an oleDbConnection object to connect
to the database server. You need to be able to retrieve the
data from the database server in XML format. Which approach
would be the most efficient? Select all that apply. Each
answer constitutes part of the whole answer.

a) Change to the SQL .NET provider.
b) Use the ExecuteXmlReader() method of the xxxCommand object
c) Use the DOM to create the XML document.
d) Use the XmlDocument.Load() method to create the XML Document.

Question Posted / raghava

1 Answers
4380 Views
Syntax Softtech, I also Faced
E-Mail Answers

You need to retrieve data from a Microsoft SQL Server 2000. Currently you are using an oleDbConnect..

Answer / g.b.prabhakaran

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More ASP.NET Interview Questions

What are the advantages of using Master Pages?

0 Answers MCN Solutions,

Is viewstate secure?

0 Answers

Explain diff. Betn dataset and recordset?

0 Answers

How can you ensure a permanent cookie?

0 Answers

Give some salient points of difference between request processor and request dispatcher.

0 Answers Tech Mahindra,

I am using a range validator and want to use dd mm yyyy format for accepting dates. I get a fairly generic "can't do that" type exception when I use this format for setting the minValue or maxValue properties for the range validator. How can I force it to accept my format?

1 Answers FutureTech,

What is the difference between the response.write() and response.output.write() methods?

0 Answers

How would you turn off cookies on one page of your website?

0 Answers

My website has around 100 aspx. Out of this, a certain 20 aspx files should be made available to the users only if they are logged in. How can I achieve this with the web.config file?

1 Answers Techno Solutions,

Where do you store the information about the user?s locale?

2 Answers

How do you install windows service?

4 Answers Tech Mahindra,

How to store a dataset in a viewstate?

3 Answers IBM,

For more ASP.NET Interview Questions Click Here