dataset is a disconnected architecture while a datareader is a connected

what are the differences between dataset and datareader?

Question Posted / hardik

Answer Posted / hardik

dataset is a disconnected architecture while a datareader
is a connected architecture object.

data reader is a faster than a dataset

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which namespaces are used for data access?

1213

How to bind the controls(best practice) comboboxes to the data in the dataset?

1050

What is the functionality of data provider in ado.net?

942

What provider ado.net use by default? Explain the role of data provider in ado.net?

971

What is the difference between Data adaptor and Data set?

1041

Which object needs to be closed?

2262

Describe datareader object of ado.net with example.

939

Why is it important to close an ado.net application?

1024

How to retrieve the user id which is provided while windows authentication?

1099

What does executereader return?

983

What are the 3 major types of connection objects in ado.net?

1001

Is it possible to edit data in Repeater control?

966

What is bubbled event can you please explain?

1049

How do I delete a row from a DataTable?

1167

What is an orm, and why would you use one instead of plain old ado.net?

1050