Sign Up Login


  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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?

Question Posted / srikanth

Answers were Sorted based on User's Feedback



We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / rumpa

By using Data Adapter Update(DataSet,DataTable)

Is This Answer Correct ?    21 Yes 6 No

We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / komal gupta

As DataAdaptor is Internally build of Select, Insert , Update and Delete Command,It can be updated via using da.Update(ds) , It will internally create Insert/Update/Delete Commnand for DataAdaptor (as per modifcation. Or else We can write specific Insert/Update/Delete Command for Every Action of User and attch these command to DataAdaptor.

Is This Answer Correct ?    4 Yes 2 No

We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / vasu

IN DataSet it will use the DataAdapter for communication
with data base when dataset updating the data DataAdapter
will open the connection automatically lost.

Is This Answer Correct ?    2 Yes 0 No

We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / venu

Ya dataset have drawback.it is not updated in database
automatically.we have to use
da.update(dataset_object,Table_name);
At this time only update the table in your database.

Is This Answer Correct ?    4 Yes 3 No

We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / 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

We all know that Dataset is purely disconnected architechure, but we also know that we can update ..

Answer / kishore

we can update it by using fill();

Is This Answer Correct ?    3 Yes 14 No

Post New Answer

More ADO.NET Interview Questions

What is ado rdo dao in visual basic?

0 Answers  

How to sort the data in Datatable

2 Answers   NetProphet,

Which method in OLEDBAdapter is used to populate dataset with records?

0 Answers  

How to enable and disable connection pooling?

0 Answers  

what are types of Dataset ?

6 Answers   HCL,




What is a datatable?

8 Answers   State Bank Of India SBI,

What is data relation?

0 Answers  

What is ole db query?

0 Answers  

What is connection string?

0 Answers  

What is ole data type?

0 Answers  

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

What are the three Objects of ADO.

10 Answers  

For more ADO.NET Interview Questions Click Here
Categories