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,

1156

What is the significance of CommandBehavior.CloseConnection ?

NA,

1162

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

1336

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?

1005

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?

1008

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

971

How do you implement locking concept for dataset?

991

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

1026

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

990

Explain the advantage of ADO.Net?

989

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

1165

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

1057

What is the DataTableCollection?

1051

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is ado.net explain with diagram?

955

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

1147

What is the usage of the dataset object in ado.net?

958

How to work with disconnected data - the dataset and sqldataadapter?

982

How to identify the controls which can be used for binding data?

993

Difference between sqlcommand and sqlcommandbuilder?

1117

Explain the advantage of ADO.Net?

989

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

1057

Does sqlclient and oledb class share the same functionality?

922

What is ado.net in vb net?

925

What are the steps to connect to a database?

1017

What does ole stand for in excel?

1141

Can datareader hold data from multiple tables?

1178

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

1034

How do I delete a row from a DataTable?

1156

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