Difference between datareader and dataset ?

Answer Posted / j_baghla

Datareader is used for readonly-forward only data.We can't
update the database by datareader.We can store more than
one resultset in the datareader so we can't create the
relations between the tables.There is no record pointer to
read the data in the datareader.We can read the datat from
the datareader by using reader method.

Dataset can contain more than one table and we can create
relationships among those tables.we can read the data by
for each loop.Dataset can contain data from different
datasources like oracle,sqlserver,access etc.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is the view state data stored in asp net?

554


What is active web page?

558


What is s2s tracking?

532


How to disable disable browser's Back button in asp.net (JavaScript)?

557


How asynchronous call can be implemented using delegates?

533






When maintaining session through sql server, what is the impact of read and write operation on session objects?

527


What is the difference between equals() and == in c#?

558


What is the purpose of url encoding?

486


What are session state modes in asp.net?

543


What are validator? Name the validation controls in asp.net? How do you disable them?

538


Can the dictionary object be created in client?s scope ?

1984


What is the difference between pathparam and queryparam?

566


What is ispostback method in asp.net? Why do we use that?

566


What are the different types of Caching techniques in ASP.NET?

567


Explain the difference between panel and groupbox classes using .net?

481