DataReader & DataSet.

Question

1.00/5 (1 vote)

See more:

Why we call data reader as connection oriented and data set disconnected architecture though we are hitting once to the database and took the values then store in either data reader or data set. After that, we are performing the task. So for this we do not need any connection. Please explain very neatly with an example.

how many records(e.g 10,0000 or 1 lakh) we can store in data reader as well as dataset and in which case we go for data reader rather than data set and vice-versa ?

What is the use of DataReader & DataSet ?

Posted 7-Nov-15 16:57pm

Member 11492333

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2015-11-08T03:16:00

The datareader doesn't store anything, it simply retrieves the next record from the datastore where the Read method is called. The connection and query remains open while each result is read one at a time. With a dataset all the data is read and stored in the dataset and the connection is no longer needed.

Krunal Rohit · Answer 2 · 2015-11-08T01:20:00

Solution 1

Or how about you read this first: DataSet vs. DataReader[^]
DataSet Vs SqlDataReader[^]
http://www.techrepublic.com/article/which-is-best-for-you-datareader-or-dataset/[^]
http://stackoverflow.com/questions/1083193/whats-better-dataset-or-datareader[^]

-KR

Posted 8-Nov-15 1:20am

Krunal Rohit