Difference between datareader and dataset ?

Answer Posted / jagadeesh naidu

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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the cookies types in asp.net?

754


What is asp net application object?

753


Is it possible to write code in many languages in one asp.net project?

768


Can user control be stored in library?

710


What is razor? : asp.net mvc

774


How do you handle server controls?

871


Describe the disadvantage of cookies.

785


In which situation can you not use a viewstate?

726


Can action method static?

757


Is viewstate secure?

735


How can you access the properties and controls of master pages from content pages?

753


Explain the difference between response.redirect vs server.transfer

871


What are the asp.net 2.0 features?

748


Explain code snippet to register exception filters from controller?

821


What is server infrastructure?

812