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

Can any object be stored in a viewstate in .net?

1122


Tell us what is the difference between struct and class?

1239


Show different types of collection in .NET?

1057


Is atl redundant in the .net world?

1046


Explain what is a delegate?

1109


What does mean by .net framework?

1269


What is the difference between .net 2000 and .net 2005(features)? Which one is better?

1030


What method do you use to explicitly kill a users session? How?

1070


What are the improvements made in cas in .net 4.0?

1011


Explain what inheritance is, and why it's important?

1034


How you apply a theme in whole application in .Net?

1304


What is il in vb.net?

1085


How is meant by dll in .net?

1098


Explain me what is the difference between an abstract class and an interface?

1077


Explain what are possible implementations of distributed applications in .net?

1051