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
4559 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

Why is catch(Exception) almost always a bad idea?

4 Answers

How to limit table cell size with long strings?

1 Answers IBS,

In asp.net 3.5 we can go one page to onther page without using statemanagment concept?

1 Answers ANR, Google, TCS,

How to manage pagination in a page?

2 Answers

What does occur first in ASP.Net, Authentication or Authorization?

0 Answers MCN Solutions,

Explain how is a property designated as read-only?

0 Answers

Explain difference between dataset and datareader?

0 Answers

a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.

0 Answers Netsweeper,

what is wpf and wcf in .net explain with an example?

2 Answers

What are the intrinsic objects present in ASP.NET

1 Answers IBM,

What is bound controls

0 Answers MCN Solutions,

If Asp Dot Application is stateless what happened? during designing

3 Answers TCS,

For more ASP.NET Interview Questions Click Here