What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
1336In how many ways we can retrieve table records count? How to find the count of records in a dataset?
1005how 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?
1008What 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
What is ado.net explain with diagram?
What are the classes in System.Data.Common Namespace?
What is the usage of the dataset object in ado.net?
How to work with disconnected data - the dataset and sqldataadapter?
How to identify the controls which can be used for binding data?
Difference between sqlcommand and sqlcommandbuilder?
Explain the advantage of ADO.Net?
Describe the disconnected architecture of ADO.NET’s data access model.
Does sqlclient and oledb class share the same functionality?
What is ado.net in vb net?
What are the steps to connect to a database?
What does ole stand for in excel?
Can datareader hold data from multiple tables?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
How do I delete a row from a DataTable?