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,

1167

What is the significance of CommandBehavior.CloseConnection ?

NA,

1171

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

1338

How would you connect to database using .NET?

1030

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

1011

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?

1016

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

974

How do you implement locking concept for dataset?

998

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?)

1003

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

1031

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

997

Explain the advantage of ADO.Net?

991

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

1169

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

1063

What is the DataTableCollection?

1055

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is variable view?

878

How to create data relations?

1000

What is data relation in ado.net?

1078

What are the core objects of ADO.NET?

1048

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

997

What is the difference between ADO and ADO.Net?

1084

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

989

Which is the feature of ado.net?

1014

What is the difference between connected and disconnected environment?

1110

What is the difference between data reader and data adapter?

1033

What are the Data providers in ADO.Net?

1019

How we can provide data to ado.net?

1044

Explain all the classes those are used for database connections between sql server and asp.net?

1009

Explain executenonquery?

1140

Is ado.net an orm?

968

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