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();

Whate are different types of Commands available with DataAdapter ?

2 Answers  

What is csdl entity framework?

0 Answers  

What is sqldatareader in ado.net?

0 Answers  

What are all the classes that are available in System.Data Namespace?

0 Answers  

Is it possible to load multiple tables in a Dataset?

0 Answers  

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

0 Answers  

What is ole in vb?

0 Answers  

What are the ado.net objects?

0 Answers  

What are the different row versions available?

3 Answers  

What is a datagridview?

0 Answers  

How to pass multiple tables in datasets simultaneously?

0 Answers  

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

0 Answers