Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Dataset and DataReader? Can
u breif me ADO.net classes and architecture
- 2 Answers
- 6589 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikanta.srinu
Dataset:1)It is a disconnceted architecture why because
once you fill data in dataset,it'll keep data in it even DB
conncetion was closed.and also no need write code for open
& close database connection.
2)It contain collection of datatables.It can be Add,Edit
and modify at runtime.This property is called Read and
write.
DataReader:
1)It is a Connceted architecture why because we have open
connection to get data from DB.
2)It is Forwarad only.This is only for Reading data from DB.
Diffrence:
==========
DataReader is faster than Dataset,because this is read only.
ADO.net classes
===============
System.data is importent class for ADO.Net.It have
collection of class like Dataset,DataReader.etc...
System.Data.SqlClient;
This is for used making SQL connetion,Command.etc..
Architecture
============
SQLDataProvider is contain DataAdpter.This is used to
retive data from DB and then fill dataset to client.and
also It can do Add,Edit and modify operation on DB.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / md irshad
1-data set like a container.it's follow the disconnected
architecture while data reader follow connected architecture.
2-data reader provide forward only and read only access to
data while data set object can hold more than one table from
the same data source.
| Is This Answer Correct ? | 1 Yes | 0 No |
questions on various scenarios on exception handling? like for example.... try { a; b; ...exception occurs here...what happens...will catch execute or will finally execute...will c execute c; } catch { a; b; c; } fianlly { a; b; }
What is Nothing permission set in .Net
How to create a key pair in .net?
What is manifest in .net?
What is the raise event used for?
What are the different types of memory in .net?
What is a Manifest?
What is clr in .net?
What is a delegate in .NET?
What are Satellite Assemblies? How you will create this? How will you get the different language strings?
What are an object and a class?
I am looking for a fast track course (MAX 15 days) in MS.NET 3.5 and SQLSERVER 2005 in hyderabad or mumbai or pune. I am working in mumbai so cannot gor for long course. Can any body suggest me the best couching class or best faculty for the same. Thanks.
Dot Net Framework 
