ADO.NET Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ADO.NET Interview Questions

Questions Answers Views Company eMail

Diff b/w DataReader,Dataset and Data table?

HCL,

5 11596

We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

Accenture, FastStream,

6 12725

what are types of Dataset ?

HCL,

6 23808

ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?

Zensar,

3 12614

What are the Different layers in ADO.Net?

7 14002

can u tell me the how to get the print for the form

Crea,

2 5245

can u tell me the why ADO does not support xml..

Crea,

2 6560

IF we have lot of records in Database. How we can handle them?

Honeywell,

5 9983

what is ado.net

Karrox, SunGard,

6 10284

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 11672

How to fetch the last inserted record in a particular table?

CarrizalSoft Technologies, Microsoft,

10 18846

How many types of data table are in SQL.NET

Chetu India, HCL, MAHINDRA,

4 16711

Differentiate between Dataset and Recordset.

2 6994

can we change the data in dataset? if yes what is the process?

Artech,

1 6793

Is ADO.NET derived from COM? true /false

Infosys,

2 7286

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

How to find the given query is optimised one or not?

981

Explain the difference in an abstract class and an interface?

929

What is the significance of CommandBehavior.CloseConnection ?

1173

Which control of the BindingNavigator returns the current position within the data source?

1175

What is the use of sqldatareader class?

1005

What is a sqldataadapter?

1002

What are the different row versions available in table?

981

What are the different ado.net namespaces?

1074

Define the executescalar method?

945

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1055

What DataReader class do in ADO.NET ?

1104

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1065

What are the drawbacks of using ado.net?

983

What are the different methods available under the sqlcommand class to access the data?

1055

What is dataset object? Explain the various objects in dataset.

1053

For More Un-Answered { ADO.NET } Questions Click Here