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

how to retrieve property settings from xml .config file.

755


What is a session in programming?

776


Explain what is the procedure to create the environment for asp.net? : asp.net mvc

808


We Only Know The Total Number Of Feet In The Farmyard. Write A Program that will compute the total number of rabbits and chickens in the farmyard. Assume number of feet in the farmyard are 40. how many rabbits and chickens are?

691


What is windows active directory authentication?

800


What threading model used in asp and asp.net?

802


What is session and cookies in asp.net?

784


How do I use a proxy server when invoking a web service?

757


Give an example of what might be best suited to place in the application_start and session_start subroutines?

753


What is role-based security in asp.net?

756


How to send a DataReader as a parameter to a remote client ?

3000


Can we use a static function with a non-static variable?

757


What are the versions of garbage collection?

1678


Explain parts of assembly?

757


I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.

1695