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

What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,

What is ado.net and its features?

0 Answers  

Which is faster entity framework or ado.net?

0 Answers  

Can we bind one datareader wid two dropdown list?

5 Answers  

How to maintain the relation between two tables in ADO.NET?

0 Answers   Petranics Solutions,

Which control of the BindingNavigator returns the current position within the data source?

0 Answers  

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers   Infosys, Wipro,

Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.

3 Answers   Directi,

Command objects uses, purposes and their methods.

0 Answers  

Using Ado.net, what front ends and back ends can you use?

10 Answers  

What is the difference between statement and preparedstatement interface?

0 Answers  

What are the different row versions available in table?

0 Answers