Answer / rumpa

By using Data Adapter Update(DataSet,DataTable)

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.

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.

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.

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.

Answer / kishore

we can update it by using fill();

can we create synonymn in ms access,sql server,my sql if so explain me with example

0 Answers  

What is Dataset Object?

0 Answers  

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,

What is a non query?

0 Answers  

What is connection pooling and what is the maximum pool size in ado.net connection string?

0 Answers  

What is row state?

0 Answers  

What are the advantages and disadvantages of using datalist?

0 Answers  

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?

6 Answers   Accenture, FastStream,

What is the difference between executenonquery () and executescalar ()?

0 Answers  

Can we load multiple tables in a dataset?

0 Answers  

What does sqldatareader return?

0 Answers  

What is ole used for?

0 Answers