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

ADO.NET Interview Questions

Questions Answers Views Company eMail

How do I delete a row from a DataTable?

UGC Corporation,

1230

What is the significance of CommandBehavior.CloseConnection ?

NA,

1211

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1398

How would you connect to database using .NET?

1080

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1048

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1054

What is method to get XML and schema from Dataset? getXML() and get Schema ()

1016

How do you implement locking concept for dataset?

1043

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

1055

How to check if a datareader is closed or opened? IsClosed()

1068

How do you merge 2 datasets into the third dataset in a simple manner?

1057

Explain the advantage of ADO.Net?

1031

Which control of the BindingNavigator returns the current position within the data source?

1208

Describe the disconnected architecture of ADO.NET’s data access model.

1108

What is the DataTableCollection?

1098

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What you mean by filtering of data?

1013

What are the advantage of ado.net?

1042

Why do we serialize data?

1005

What is ado object model?

992

Explain what are the steps to connect to a database?

1015

What is ado oledb and odbc?

984

Explain the various objects in dataset.

1046

How to creating a SqlCommand Object?

1197

What are basic methods of dataadapter?

1012

How can we add/remove row's in "datatable" object of "dataset"?

1061

What are the difference between readonly vs. Const?

1059

Explain the two fundamental objects in ado.net?

1067

What is linq and entity framework?

1061

What are all features of ADO.Net?

1041

What is the default timeout specified for "sqlcommand.commandtimeout" property?

1104

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