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

What is __ requestverificationtoken?

752


How asynchronous call can be implemented using delegates?

773


Are there resources online with tips on asp to asp.net conversions?

766


Disable browser cache for entire ASP.NET website?

884


Explain the advantages of passport authentication.

697


When using the Pager object, inorder to know which page to go, which property you have to set to grid?

762


Explain the advantages of asp.net.

737


Explain authorization levels in .net ?

810


Why session management is required?

747


Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?

864


Explain form level validation and field level validation?

769


Describe the Server Control Events of ASP.NET?

891


How do u declare static variable and how it is declared and what is its lifetime?

751


How to use ipostback?

793


Why session is more secure than cookies?

687