* Dataset can fetch source data from many tables at a time, for Recordset you can achieve the same only using the SQL joins.
* A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.
* A DataSet is designed to work without any continues connection to the original data source; Recordset maintains continues connection with the original data source.
* DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.
Posted Date:- 2021-09-18 09:24:54
Describe ADO.NET Architecture?
Explain role-based security in .NET
What is the meaning of CAS in .NET?
Explain Microsoft Intermediate Language
What is the difference between int and Int32?
What are the different methods available under sqlcommand class to access the data?
Does an OleDbCommand object need to be closed?
What keyword is used to accept a variable number of parameter in a method?
What two classes are used to execute arbitrary SQL commands in a database using ADO.NET?
What two classes are used to open and connect to a database using ADO.NET?
What two classes are used to read data only?
What method is used by the Command classes to execute SQL statements that return single values?
Does an OleDbCommand object need to be closed?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is the use of parameter object?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is the difference between "Optimistic" and "Pessimistic" locking?
What is the preferred method for executing SQL commands that contain parameters?
What two classes are used to execute arbitrary SQL commands in a database using ADO.NET?
What is BindingSource class in ADO.NET?
What is GetChanges() method in ADO.NET?
Hpw DataSet objects in ADO.NET replace the ADO Recordset object?
What is the preferred method for executing SQL commands that contain parameters?
What you understand by ExecuteNonQuery Method?
Describe the System.Data Namespace Class?
Which objects need to be closed?
What are the important features of ADO.Net 2.0?
What are the important features of ADO.Net 2.0?
What is the difference between Data Grid and Data Repeater?
What is the usage of the DataSet object in ADO.NET?
Name the different methods by which you can populate a dataset?
What do you mean by Batch Updates?
What are the major challenges in accessing data from a database?
What is the difference between Integrated Security = True and Integrated Security = SSPI?
What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?
What Are All The Different Authentication Techniques Used To Connect To Ms Sql Server?