What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
771In how many ways we can retrieve table records count? How to find the count of records in a dataset?
542how 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?
581What 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?)
581
Explain advantages of ado.net?
What are the different ado.net namespaces are available in .net?
What is Dataset Object?
Why do we need ado.net?
What is disconnected data?
What is sql connection in ado.net?
What is the difference between ADO and ADO.Net?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What are the uses of Stored Procedure?
What are the ado.net connection pooling parameters?
How to work with disconnected data - the dataset and sqldataadapter?
What is DataRowCollection?
How do you update a dataset in ado.net and how do you update database through dataset?
How to aggregating data across related tables?
Can you explain how to enable and disable connection pooling?