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?

1045

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

930

What are the advantage of ado.net?

937

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

1033

What is bubbled event can you please explain?

971

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

1275

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?

969

What is the executescalar method?

1023

Explain the role of data provider in ado.net?

935

What is isolation?

971

What are the different row versions available in table?

912

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?

1009

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

1042

What are the steps to connect to a database?

978

What is connection string?

956

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is the provider being used to access oracle database?

939

What is Serialization in .NET? what are the types of Serialization?

1026

What is the significance of CommandBehavior.CloseConnection ?

1096

What are basic methods of dataadapter?

929

Give few examples of datareader that is used in different dataproviders.

928

What is ado.net components?

901

What is the difference between typed and untyped dataset?

990

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

972

How do I delete a row from a DataTable?

1079

What are the steps you will take to improve performance?

842

Why is ADO.NET serialization slower than ADO ?

1002

How to add a javaScript function in a datagrid?

1062

Which is faster ado.net or linq?

955

What are the data access namespaces in .NET?

1135

What is difference between Dataview and Datatable?

1000

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