Diff b/w DataReader,Dataset and Data table?

Answer Posted / sooraj

dataset :-
dataset used disconnected mode(offline architecture) dataset
contain object of data table by using dataadapter by fill
method means dataadapter fill the fetch query of datatable
to data set..

datareader:-
its use connected mode arcetecture..its secure but
connection oriented.. its working some time we can say that
its same as a dataset but its direct access data by table..

datatable :- structured format it contain
a rows and columns.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need ado.net?

545


What is difference in record set and dataset?

538


Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

560


What is the difference between sqldatareader and sqldataadapter?

496


What is ole word?

541






What is the meaning of executenonquery?

540


What are dataproviders?

550


differance between ADO vs ADO.Net?

550


Define isolation?

538


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

587


Which property is used to check whether a DataReader is closed or opened?

572


Explain how to call the sql commands asynchronously in ado.net version 2.0?

514


Some important instruction regarding ADO.NET connection string ?

546


How to create dynamic gridview?

592


Which keyword is used to accept variable number of parameters?

688