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

ADO.NET Interview Questions

Questions Answers Views Company eMail

Advantage of ADO.Net?

QualSoft, TCS,

2 9158

How would u connect to database using .NET?

Tesco, TCS,

5 6753

What are relation objects in dataset and how & where to use them?

1 4066

Difference between OLEDB Provider and SqlClient ?

2 8767

What are the different namespaces used in the project to connect the database?

3 5066

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

TCS,

3 29691

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

4 7908

Explain different methods and Properties of DataReader which you have used in your project?

2 5428

What happens when we issue Dataset.ReadXml command?

1 4713

How to find the count of records in a dataset?

6 18287

How to check if a datareader is closed or opened?

1 16152

What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

TCS,

1 17999

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 9482

Differences between dataset.clone and dataset.copy?

TCS, Ksb,

2 5710

What is the use of parameter object?

Ksb, CDC,

4 7089

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

Define Execute Reader?

104

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

What is a control toolbox?

What is difference between datareader and dataadapter?

Describe briefly an ADO.NET Dataset ?

Compare Data Reader & Dataset in ado.net?

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

What is disconnected architecture in ado.net?

What is the difference in an abstract class and an interface?

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

What is bubbled event can you please explain?

How to connect and retrieve data from database using dataset

What is difference between executequery and executeupdate?

What is the purpose of using adodb?

Give an example that shows how to execute a stored procedure in ado.net?

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