Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
- 3 Answers
- 10255 Views
- HCL, NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / irfanpathan
Dataset is used to get the data from database by creating
objects..After getting data we should store that data.we
use SQLDATAADAPTER for storing data..after storing we will
give connection with SQLCONNECTION class.and then we bind
the data using DATABIND..This total process is appliued
with DATASET.
where as DATAREADER is also for getting data through
database.But it is faster in access.we wont use DATAREADER
because of performance problem..
i too dont know record set..
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / lavanya
With Dataset can retrive the data from two database like
oracle, SQl and merge in one table. Record set is not
possible.
All representation of dataset is using XML while record set
use COM.
Recordset can not be transmitted on HTTP while Dataset can
be.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / lovenier
We use DataSet to retrieve data from database in disconnected mode, but in the data RecordSet it retrieve data in connected mode..
DataSet is designed to work without any continuing connection to the orignal database, but RecordSet is Required a connected environment.
Data in DataSet is bulk loaded, rather than being loaded on demand.
DataSet have no concept of Cursor and current pointer, you can use for each loops to move through data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is cookies cache and session?
What do you mean by serialize?
Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
which one is faster execute reader, scalar, execute non query ?
WSDL means?
Can we use html in asp.net?
What is the used of "ispostback" property?
Explain how do you validate the controls in an asp .net page?
Which template must you provide, in order to display data in a Repeater control?
Which template must you provide, in order to display data in a Repeater control?
How to implement role based security in asp.net mvc? : Asp.Net MVC
What are user controls and custom controls ?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
