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 is application Object?

777


Which type if caching will be used if we want to cache the portion of a page instead of whole page?

687


What is caching in asp.net?

752


Difference between application events and session events

783


What is the difference between page.registerclientscriptblock and page.registerstartupscript?

649


3. What goals do you have in your career?

1611


What is the use of ASP.NET routing?

757


How can we create Tree control in asp.net?

785


What is caching? Explain.

735


What are validator? Name the validation controls in asp.net?

731


what are the events raised in asp.net page life cycle?in which stage view state can be loaded?

749


How can we make sure that Web API returns JSON data only?

761


What is session in http request?

778


How can we create a website?

719


What is datagrid asp.net?

720