What is main five diffrent between Connected And
Disconnected environment
Answer Posted / srikanth
Hi.. Questn is about diff b/w connctd and dis connctd. not
b/w reader and data set..
Connected:-
data provider comes under connected eniv. data
povider contains four components
(Connection,Datareader,Command,DataAdapter).
Dissconnected:-
It contains only DataSet.
Connected:-
In this asynchronous or multiple access can be
doing by using MARS(Multiple Active rsult set)
Discon:-
Is used for async
Connected:-
always there is a direct contact to database
disconnected:-
Not required
Connected:-
Less chance of Diry read
disconnec:-
More
Connected:-
Low Perfomance bcz bulk updation is process taking
disconnected:-
can be done easily and update at a time
| Is This Answer Correct ? | 26 Yes | 14 No |
Post New Answer View All Answers
What is the meaning of executenonquery?
What is difference between ado and other data object?
What are the major difference between classic ADO and ADO.NET?
What is the difference between sqldatareader and sqldataadapter?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is connection string?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
What are the methods of XML dataset object?
What are the different row versions available in table?
What do you mean by performing asynchronous operation using command object?
What is ado.net in mvc?
How do you implement locking concept for dataset?
What is the executescalar method?
Which is better ole db or odbc?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?