What is main five diffrent between Connected And
Disconnected environment

Answer Posted / srikar

Data-reader:

It is connection oriented.
It is faster.
It is Read only,we can't update the data.
it access one table at at a time.

Data set:

It is dis_connection oriented.
it is slower compare to Data-reader.
It access more one table at a time.
We can update data also.

Is This Answer Correct ?    48 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ado control?

526


What does executenonquery () method return?

502


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1640


Can you explain how to enable and disable connection pooling?

506


What is the difference between sqldatareader and sqldataadapter?

494






Explain all the classes those are used for database connections between sql server and asp.net?

507


What is the role of the dataset object in ado.net?

571


Command objects uses, purposes and their methods.

523


Some important instruction regarding ADO.NET connection string ?

544


Explain how can we load multiple tables in to dataset?

500


How would you connect to a database by using .NET?

482


What is the difference between a datareader and a dataset?

518


What is difference between ado and other data object?

470


What is partial class?

550


Explain the basic use of "dataview" and explain its methods.

532