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

ADO.NET Interview Questions

Questions Answers Views Company eMail

Which method in OLEDBAdapter is used to populate dataset with records?

962

Which object needs to be closed?

2195

What are different layers of ADO.Net?

1041

What are typed and untyped dataset?

1045

Which method is used to sort the data in ADO.Net?

1922

Which object is used to add relationship between two Datatables?

980

Which is the best method to get two values from the database?

921

What are all the classes that are available in System.Data Namespace?

963

What are the uses of Stored Procedure?

1007

What is the default Timeout for SqlCommand.CommandTimeout property?

957

What are the classes in System.Data.Common Namespace?

1089

What are the methods of XML dataset object?

988

What are all the different authentication techniques used to connect to MS SQL Server?

1010

Which method is used by command class to execute SQL statements that return single value?

984

What are the 3 major types of connection objects in ado.net?

940

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

Explain how to pass multiple tables in datasets simultaneously?

988

What are the methods of XML dataset object?

988

Define ado.net?

1037

What is shadow copy?

935

Define bubbled event?

870

What do you mean by performing asynchronous operation using command object?

970

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

Describe briefly an ADO.NET Dataset ?

1004

What is openrowset?

923

What are the data providers used in ado.net

971

Which database is the ado.net?

917

Why is stored procedure used in ado.net?

1032

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

862

What is the difference between data reader and data adapter?

967

Why do we use sqldataadapter?

908

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