.NET dataset objects

.NET dataset objects - Interview questions

<<Previous  Next>> What is Dataset object? Databases           | DataProviders           | DataAdapters           | DataSets.....................     What are the various objects in Dataset?      The DataSet class exists in the System.Data namespace. The Classes contained in the DataSet class are:.............. How to save data from dataset?      The modified data needs to be sent back to the database in order to save it. Therefore, to send the modified data to a database............... Explain the difference between dataset clone and dataset copy? Dataset.clone() duplicates (only) the structure of a dataset, without duplicating the data............... Explain the difference between DataSet and DataReader Datareader fetches one row at a time from the datasource. DataSet fetches all data from the datasource at a time to its memory area.............. <<Previous  Next>> Also read ADO.NET This is complete article on ADO.NET with code and interview questions Difference between dataset and datareader. DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them.......... What are basic methods of Dataadapter? This method executes the SelectCommand to fill the DataSet object with data from the data source........... How can we check that some changes have been made to dataset since it was loaded? The changes made to the dataset can be tracked using the GetChanges and HasChanges methods.......... Explain the basic use of “DataView” and explain its methods. A DataView is a representation of a full table or a small section of rows, it is used to sort and find data within Datatable.  What’s difference between “Optimistic” and “Pessimistic” locking? In pessimistic locking, when a user opens a data to update it, a lock is granted....