ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Microsoft Related >> VB.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions (615)
 C Sharp interview questions  C Sharp Interview Questions (722)
 ASP.NET interview questions  ASP.NET Interview Questions (1444)
 VB.NET interview questions  VB.NET Interview Questions (151)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (199)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
Question
What is the difference between Dataset and Recordset?
 Question Submitted By :: VB.NET
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

3) Recordset can not be transmitted on HTTP while Dataset
can be.
 
Is This Answer Correct ?    42 Yes 5 No
Shweta Mogadpally
 
Answer
# 2
? 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.
 
Is This Answer Correct ?    27 Yes 15 No
Vinayak
 
 
 
Answer
# 3
With Recordset comes the Recordset pointer, that points to
the relative data so retrieved from the database. The
Recordset object has MoveNext, MoveFirst, MovePrevious and
MoveLast methods that provides a means for Data Traversal

With DataSet there is no pointer that points to the record,
while a Bulk of Data is retrieved from the Database to the
Computer's Memory, and the record is accessed via the index
of the Record so retrieved.

With Recordset, has types of Cursors ie. Open Cursor and
Data Manipulation Cursor, which enables the cursor to be
open as read-only or dynamic (meaning for data
manipulations)

With Dataset as bulk of data is loaded to the Memory, only
Viewing operation is possible.

With Recordset, if the cursor is open as OpenDynamic and
OpenOptimistic, the Data manipulated by 1 user, its effect
is visible to the other user, leading to clear picture of
the Database, while this is not the case in DataSet.

DataSet can be viewed as a ONE WAY HIGHWAY, where the data
comes from Database to the Computer's Memory.
RecordSet can be viewed as a TWO WAY HIGHWAY, based on and
according to the Cursor type selected in the recordset
 
Is This Answer Correct ?    16 Yes 9 No
Haynes R. Rajwadi
 
Answer
# 4
The Recordset was not XML-based and could not be serialized
to XML easily or flexibly.
Finally, a Recordset was not independent of a data store
because it tracked a Connection object
and through its methods could send queries to the data
source to populate, update,
and refresh its data.
To that end, the Recordset contained functionality found in
the ADO.NET DataSet,
data reader, and data adapter objects.

Similar to the DataSet, a Recordset could be disconnected
from its data store
and therefore act as an in-memory cache of data.
Of course, it could also be used in a connected model
depending on the cursor options that were set.
Although the Recordset object stored multiple versions of
each column for each of its rows,
it was not by nature able to represent multiple tables
without the use of the Data Shape Provider.
 
Is This Answer Correct ?    11 Yes 4 No
Sathiyapriya
 
Answer
# 5
1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

3) Recordset can not be transmitted on HTTP while Dataset
can be.
 
Is This Answer Correct ?    12 Yes 10 No
Shweta Mogadpally
 
Answer
# 6
1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

3) Recordset can not be transmitted on HTTP while Dataset
can be
 
Is This Answer Correct ?    6 Yes 7 No
Rahul
 
Answer
# 7
With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

3) Recordset can not be transmitted on HTTP while Dataset
can be
 
Is This Answer Correct ?    2 Yes 3 No
Sanny
 

 
 
 
Other VB.NET Interview Questions
 
  Question Asked @ Answers
 
What is JIT(Just In Time) and How it works? Infocons 5
What is the Difference between Web User Control and Web Custom Control?   6
What is the difference between Dataset and Recordset? Silicon 7
diff b/w windows and console application?   3
1.wht is satellite assembly??? 2.How Garbage Collector works can u explain ???? ABC 3
i have attended interview for cognizant ( 3 +,on .net ) on 19-06-2010 till now i have not given the status ..am confused... does any one faced same situation ...could please tell what would be happened   1
There are three versions of VB6--Learning Edition, Professional and Enterprise. Is VB.Net similar?   1
write a VB.net program to swap two numbers   4
How to create Crystal Report in vb.net with coding Ascent 1
What is difference between a panel and GroupBox ? GHK 3
give me code for selecting itemcode and correspondin vendor details wll displays in the gridview?   1
is ADO.NET important to connect sql server? is any other way to connect sql server?   1
 
For more VB.NET Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com