DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Recordset Vs Dataset

  1. #1
    Join Date
    Oct 2005
    Location
    India
    Posts
    25

    Thumbs up Recordset Vs Dataset

    hai,
    In Vb.net We can use for retrieving data from the database ,dataset as well as recordset.In these two things which one will be good.And what are the disadvantage and advantage of these two things.If anyone knows please give me an answer.

    regards,

    VipinB

  2. #2
    Join Date
    May 2005
    Location
    UK
    Posts
    278

  3. #3
    Join Date
    Nov 2005
    Posts
    2
    RecordSet is used in VB 6.0 and DataSet in VB.NET

    RecordSet is operate in Connection Oriented Manner i.e. For Each Query and Each Record The Request goes to the database and after that user will get result.
    In RecordSet we can use only one database for Data operations.
    by Using DataSet
    DataSet is operate in Disconnected Manner i.e unlike the Recordset we don't Need to send query for each record instead of it Dataset can retrive all the information at a time so it operates in disconnected manner and we can use more that one database for data retriving using dataset.

    So..........
    RecordSet is Required More time than DataSet For data retrival
    DataSet is always Better than the RecordSet.

  4. #4
    Join Date
    May 2005
    Location
    UK
    Posts
    278
    yes I guess thats how ADO.net scores some points over traditional ADO
    Sri

  5. #5
    Join Date
    Nov 2004
    Location
    Huddinge, Sweden
    Posts
    283
    As usual, this ís a gross oversimplification. It's true that a DataSet will have all the data locally. However, this is both a curse and a blessing. It means all the data will have to be fetched before any work can be done, which may increase latency and memory usage substantially.

    The Recordset is cached behind the scenes, so there will only be roundtrips to the server when needed to refill the cache.

    BTW, in .NET the equivalent of a Recordset is the SqlDataReader (or equivalent for datasources other than SQL Server). It can return multiple results, but you have to process them one by one in order.

    Most of the time a DataReader is the fastest method.

    Rune
    If you hit a brick wall, you didn't jump high enough!

Similar Threads

  1. Copy a DataSet in memory
    By michael in forum ASP.NET
    Replies: 1
    Last Post: 04-15-2003, 11:42 AM
  2. Replies: 0
    Last Post: 11-13-2001, 12:34 PM
  3. Creating a Recordset
    By Scott in forum ASP.NET
    Replies: 0
    Last Post: 11-12-2001, 10:14 PM
  4. Requerying a reshaped recordset
    By Jonathan Gibbs in forum VB Classic
    Replies: 0
    Last Post: 08-09-2001, 02:34 PM
  5. ?Build a Recordset from an Existing Recordset
    By Patrick in forum VB Classic
    Replies: 1
    Last Post: 10-11-2000, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center