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

ADO.NET Interview Questions

Questions Answers Views Company eMail

What are the advantages and drawbacks of using ado.net?

1159

Name which operations can you not perform on an ado.net dataset?

1048

What are the advantage of ado.net?

1048

What are good ado.net object to replace to ado recordset object.

1209

What is bubbled event can you please explain?

1112

If we are not returning any records from the database, which method is to be used?

1375

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1087

What is the executescalar method?

1178

Explain the role of data provider in ado.net?

1053

What is isolation?

1079

What are the different row versions available in table?

1034

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?

1108

How do you connect to sql server database without using sqlclient?

1176

What are the steps to connect to a database?

1074

What is connection string?

1058

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

1109

How is it possible to get 2 tables of data at a time by using data reader?

999

What are the steps you will take to improve performance? Will you use dataset or datareader?

1053

What is an example of ordinal data?

1244

What is basic use of data view?

1047

What is the difference between sqlcommand and sqldataadapter?

1044

What is the difference between Datareader and Dataset?

1136

Why is ADO.NET serialization slower than ADO ?

1105

Which provider is used to connect ms access, oracle, etc…?

1062

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

1085

What are all the commands used with Data Adapter?

1097

Can we connect two dataadapters to same data source using single connection at same time?

1036

What is the use of data grid?

1002

What are all features of ADO.Net?

1048

Is bulk insert faster than insert?

971

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