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 11865

How would u connect to database using .NET?

TCS, Tesco,

5 10662

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

1 5983

Difference between OLEDB Provider and SqlClient ?

2 11287

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

3 8004

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

TCS,

3 32962

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

4 11972

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

2 7735

What happens when we issue Dataset.ReadXml command?

1 6541

How to find the count of records in a dataset?

6 22833

How to check if a datareader is closed or opened?

1 19667

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

TCS,

1 20273

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 13287

Differences between dataset.clone and dataset.copy?

Ksb, TCS,

2 8242

What is the use of parameter object?

CDC, Ksb,

4 10469

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What are the Features of a dataset

1210

What is data adapter in ado.net with example?

963

What is the meaning of executenonquery?

981

What providers does Ado.net uses?

964

What do you know about ado.net's methods?

1063

How to check if the Dataset has records ?

957

How to store data in memory?

903

What is the meaning of object pooling?

1146

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

1030

Explain why edit is not possible in repeater?

999

What are different layers of ADO.Net?

1055

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

939

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

1012

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

833

What is different between sqlcommand object and command behavior object?

1002

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