What is main five diffrent between Connected And
Disconnected environment

Answer Posted / chowdary

Data Reader:-
Data Reader is a read only and forward only data
You can access one table at a time.
Data reader cant persist the data.
Data Reader is connected architecture.
Data Reader is faster than Data Adapter
Data Reader is faster than dataset operation
Data Set:
Data Set is disconnected architecture.
Data Set is persist the data.
You can access more than one table
Data Set is main for storage tool in ADO.Net

Is This Answer Correct ?    70 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is stored procedure used in ado.net?

749


Explain the advantages and disadvantages of using datalist?

779


What is the use of SqlCommand object?

851


Explian About DataAdapters

765


What is sqldatareader in ado.net?

657


What are the types of databinding?

707


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

802


How to bind the controls(best practice) comboboxes to the data in the dataset?

750


What is an ado?

715


How to work with disconnected data - the dataset and sqldataadapter?

711


The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1784


Which is the feature of ado.net?

721


What is difference between Dataview and Datatable?

710


Describe briefly an ADO.NET Dataset ?

716


What are the disadvantages of using datalist?

685