Click here to Skip to main content
14,301,651 members
Rate this:
Please Sign up or sign in to vote.
See more:
when we use dataset and when datareader? why? if we want to edit 1000 records in database which is the best dataset or datareader?
Posted
Comments
   
1000 records, and..?
--SA
Rate this:
Please Sign up or sign in to vote.

Solution 1

There is no one single unambiguous answers to the question when and why. It depends on many factors in too many different scenarios. You don't need to observe all thinkable scenarios at once, right? Your reference to 1000 records tells us almost nothing.

The whole approach is wrong. You should first learn how things work and then try to link this knowledge with your problem and requirements trying to use logical reasoning.

I usually recommend this CodeProject article for starters: Using ADO.NET for beginners[^].

See also:
http://en.wikipedia.org/wiki/ADO.NET[^],
a place to start: http://msdn.microsoft.com/en-us/library/aa286484.aspx[^].

—SA
   
Comments
thatraja 26-Jan-12 5:17am
   
Yep, that's a nice CP article, 5!
Sergey Alexandrovich Kryukov 26-Jan-12 11:32am
   
Thank you, Raja.
--SA
Rate this:
Please Sign up or sign in to vote.

Solution 2

Here are some pages which may be useful for you :
http://www.4guysfromrolla.com/articles/050405-1.aspx[^]

http://www.sitepoint.com/dataset-datareader/[^]

http://ramanisandeep.net/2009/09/21/datareader-vs-dataset/[^]

Google for DataReader vs DataSet for more results.
   
Comments
thatraja 26-Jan-12 5:18am
   
5! Now you are a platinum authority
Amir Mahfoozi 26-Jan-12 5:22am
   
Wow ! yes thanks a lot Thatraja :) It's wonderful ;)
Sergey Alexandrovich Kryukov 28-Jan-12 17:40pm
   
I want to join the congratulations!
My 5, too.
--SA
Amir Mahfoozi 29-Jan-12 0:01am
   
Thanks SA :)

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100