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,

1166

What is the significance of CommandBehavior.CloseConnection ?

NA,

1169

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?

1009

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?

1015

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

974

How do you implement locking concept for dataset?

996

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

1000

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

1029

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

995

Explain the advantage of ADO.Net?

990

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?

1053

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

Explain the differences between oledb sql server, oledbdotnet provider?

1014

What is basic use of data view?

1007

What is datasource in ado.net?

1072

Why do we use sqldataadapter?

951

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

2029

What is ado oledb and odbc?

945

What we do with the object of ado.net dataset after using it?

1041

What is the difference between DataReader and DataSet in ADO.NET?

1161

What is ado in agriculture?

966

What is a sqldataadapter?

998

Define data access layer?

958

What are the major difference between classic ADO and ADO.NET?

1012

What is the meaning of object pooling?

1235

What is the difference between Data adaptor and Data set?

1041

If a table contains 20000 records. In a page at each time 100 records to be displayed.

890

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