Recordset Vs Dataset

[vipinb]

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

[srinivas_s]

http://www.geekinterview.com/question_details/15809

see this

[fcpmcs2005]

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.

[srinivas_s]

yes I guess thats how ADO.net scores some points over traditional ADO

[Rune Bivrin]

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