In ADO.NET Two types of Architectures are there one is connection oriented

Data Reader Vs DataSet

Question Posted / ramu

5 Answers
7363 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / ramu

In ADO.NET Two types of Architectures are there one is connection oriented another one is disconnected architecture.
DataReader,DataSet Both are frontend objects to querying on Datasource,both objects operation is similar but small difference is there

DataReader used in Connection oriented and it stores one table at a time ,it reads data from datasourse forward direction only,it can't work for backward read and one more thing is Datareder is readonly.

Dataset used in disconnected oriented and it stores more than one table,it read/write date from database both forward and backward directions.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Code for Creating a Form Using PlaceHolder Controls?

2348

What is the code of Password Recovery or Forget your password? Plz tell in c # language.

3570

how to create a search bar which access data from various websites and retrieves the data

2554

How to Bind Nested XML to a Repeater Control with Container.DataItem?

3220

how to track links visited in google using iframes

2282

Code for Presenting Parent/Child Data in a Data Grid Row?

2112

ArrayList declaration in .net

2746

Code for Document Validation in XML.NET?

1985

Coding for .NET Delegates?

2097

Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.

2251

Code for Using Keyboard Events?

2132

How to use Client-side Script to Focus Controls in ASP.NET?

2363

i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this

2145

How we use ajax in asp.net through javaScript. Please givee me an example.

2505

Code for Communicating over Sockets?

1950