We all know that Dataset is purely disconnected
architechure, but we also know that we can update the
changes made to the dataset can be updated in the backend
database. when there is no connection how does the update
happedn?

Answer Posted / neha

DataAdapter helps in updating back the database through its
update method. That is,
adapter.Update(ds);

It does this even when the connection is closed. Actually,
data adapter opens connection object to update the records,
after the records are updated, the connection is closed
again. Since there must be some path from application to
database in order to update and retrieve records. Thus, to
do this, adapter uses the connection.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe ado.net object model in detail.

534


What are the advantages of using datalist?

511


What are the different row versions available in table?

530


Which method is used by command class to execute SQL statements that return single value?

557


What is dbcontext and dbset in entity framework?

486






Which keyword is used to accept variable number of parameters?

686


Describe datareader object of ado.net with example.

511


What is difference between entity framework and ado.net?

481


What are the difference between readonly vs. Const?

506


What are the namespaces used in ADO.Net to connect to a database?

599


What is data adapter in ado.net with example?

518


How does entity framework work?

466


Explain ODP.net

571


What is a control toolbox?

505


What are all the different authentication techniques used to connect to MS SQL Server?

546