Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?

988


What's the problem with .net generics?

980


Compare client server application with n-tier application

913


Explain the main components in .net?

1061


how can i create a table from front end to back end in wabe page?

1909


Explain the difference between public and static modifiers?

1133


What is a .net class?

1184


What are the core differences between .NET Languages ?

2373


Describe the difference between inline and code behind which is best in a loosely coupled solution?

2801


Should I implement finalize on my class? Should I implement idisposable?

996


Tell me what is serialization?

1018


What is meant by localization?

1189


Explain clr, cts and cls?

1088


Explain garbage collection?

964


Please explain what is the difference between a class and an object?

1041