IT Community - Software Programming, Web Development and Technical Support

Difference between ADO.NET dataset and ADO Record set?

This is a discussion on Difference between ADO.NET dataset and ADO Record set? within the ASP and ASP.NET Programming forums, part of the Web Development category; Hi, can any one briefly explain difference between ADO.NET Dataset and ADO Recordset? Thanks, Prasath.k...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > ASP and ASP.NET Programming

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 07-18-2007, 06:52 AM
prasath prasath is offline
D-Web Sr.Programmer
 
Join Date: Jul 2007
Location: Chennai
Posts: 173
prasath is on a distinguished road
Thumbs down Difference between ADO.NET dataset and ADO Record set?

Hi,
can any one briefly explain difference between ADO.NET Dataset and ADO Recordset?

Thanks,
Prasath.k
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 07-18-2007, 08:06 AM
Arun Arun is offline
D-Web Trainee
 
Join Date: Mar 2007
Posts: 43
Arun is on a distinguished road
Post Re: Difference between ADO.NET dataset and ADO Record set?

A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.

A DataSet is designed to work without any continuing connection to the original data source.

Data in a DataSet is bulk-loaded, rather than being loaded on demand.

There's no concept of cursor types in a DataSet.

DataSets have no current record pointer You can use For Each loops to move through the data.

You can store many edits in a DataSet, and write them to the original data source in a single operation.

Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can we sort the values in dataset? mobilegeek C# Programming 4 04-18-2008 04:39 AM
Removing duplicate rows in a DataSet shaalini ASP and ASP.NET Programming 2 02-13-2008 09:33 PM
Read XML by Dataset gp_logesh ASP and ASP.NET Programming 0 10-31-2007 03:13 AM
how to update dataset to sql server? smani ASP and ASP.NET Programming 1 09-06-2007 07:29 AM
Can anybody explain about the differences between dataset.clone and dataset.copy? kingmaker C# Programming 2 08-28-2007 12:22 AM


All times are GMT -7. The time now is 03:25 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0