once data is fetched into dataset connection gets closed. but in datareader co

once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?

Question Posted / darshan.naokhare

2 Answers
6011 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

once data is fetched into dataset connection gets closed. but in datareader connection is always m..

Answer / hhh

DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster

Is This Answer Correct ?

9 Yes

0 No

once data is fetched into dataset connection gets closed. but in datareader connection is always m..

Answer / abhishek

datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

Is it possible to edit data in Repeater control?

0 Answers

What are the steps you will take to improve performance?

0 Answers

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers

Explain how do you connect to sql server database without using sqlclient?

0 Answers

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers

What are different layers of ADO.Net?

0 Answers

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

5 Answers HCL,

Explain the dataadapter class in ado.net?

0 Answers

How can you implement sub data grid in a master datagrid?