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

Which object needs to be closed?

1967


What is untyped dataset?

779


Explian About DataAdapters

773


How to generate a single aggregate?

726


What connected data?

683


Explain sqlconnection object?

745


Give an example of a .net application which connects to microsoft access database using ado.net classes.

788


What is execute reader in ado.net?

683


What is the use of data grid?

693


What is the usage of the dataset object in ado.net?

675


What DataReader class do in ADO.NET ?

777


Explain the difference in record set and dataset?

670


What are the namespaces used in ADO.Net to connect to a database?

789


How to maintain the relation between two tables in ADO.NET?

744


Explain how to find the given query is optimised one or not?

705