Difference between dataset and datareader [Resolved]

Posted by Kundan under C# on 5/14/2013 | Points: 10 | Views : 4282 | Status : [Member] | Replies : 1
Please give the Difference between dataset and datareader?




Responses

Posted by: aswinialuri-19361 on: 5/15/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
hi
Data reader that is ado.net connected architecture.
Data set that is ado.net disconnected architecture.
Data set is slower than data reader because extra overheads like relations, multiple tables etc.
If we need to move back while reading records, "data reader" doesn't support this functionality.
DataReader provide forward-only and read-only access to data, while the Dataset can hold more then one
table.

I hope it is easy o understand
Thanks& Regards



Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Kundan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response