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

Answers were Sorted based on User's Feedback



What is the difference between Dataset and DataReader? Can u breif me ADO.net classes and architec..

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

What is the difference between Dataset and DataReader? Can u breif me ADO.net classes and architec..

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

Post New Answer

More Dot Net General Interview Questions

What operating systems does the .net framework run on?

0 Answers  


Do I have any control over the garbage collection algorithm?

0 Answers  


String[] a = new string[10] for(i=0; i<10; i++) { a[i] = i; } How many heap object will be created for this array. Choose the answer below. Ans: 1, 10, 11, 12

6 Answers  


Explain dataset.acceptchanges and dataadapter.update methods in .net?

0 Answers  


Explain what are an object and a class?

0 Answers  


How will you load an assembly which is not referenced by current assembly?

0 Answers  


What is the concept of inheritance and how it works in .net?

0 Answers  


How do you turn off cookies for one page in your site?

3 Answers   Siebel Systems,


How to implement datagrid in.net? How would you make a combo-box appear in one column of a datagrid? What are the ways to show data grid inside a data grid for a master details type of tables? If we write any code for datagrid methods. What is the access specifier used for that methods in the code behind file and why?

0 Answers  


what is event inheritance and event delegation?

1 Answers  


What is meant fulltrust?

1 Answers  


What are the purposes of using .net?

0 Answers  


Categories