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 12058

How would u connect to database using .NET?

TCS, Tesco,

5 11038

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

1 6131

Difference between OLEDB Provider and SqlClient ?

2 11526

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

3 8296

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

TCS,

3 33254

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

4 12314

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

2 7934

What happens when we issue Dataset.ReadXml command?

1 6700

How to find the count of records in a dataset?

6 23300

How to check if a datareader is closed or opened?

1 19888

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

TCS,

1 20444

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 13696

Differences between dataset.clone and dataset.copy?

Ksb, TCS,

2 8491

What is the use of parameter object?

CDC, Ksb,

4 10810

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is the default Timeout for SqlCommand.CommandTimeout property?

1065

Is bulk insert faster than insert?

958

What is the use of data grid?

997

Difference between sqlcommand and sqlcommandbuilder?

1188

Why do we need ado.net?

1023

What is ado control?

996

Explain advantages of ado.net?

1097

What is ambient transaction?

999

What are the Data providers in ADO.Net?

1066

What is DataReader Object?

1093

What are the Features of a dataset

1375

What is data adapter in ado.net with example?

1103

Why is it important to close an ado.net application?

1068

What is commandbuilder in ado.net?

1099

What is difference between executequery and executeupdate?

1092

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