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

Explain the advantage of ADO.Net?

0 Answers  

What are the ado.net connection pooling parameters?

0 Answers  

What are the 4 types of classes in ADO.NET?

5 Answers  

What is sqldatareader in ado.net?

0 Answers  

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers  

What is a datatable?

8 Answers   State Bank Of India SBI,

Does dapper use ado.net?

0 Answers  

how we can fire event in databound coulm in datagfrid withot using button?

0 Answers   Tech Mahindra,

Explain ODP.net

0 Answers  

What is different between sqlcommand object and command behavior object?

0 Answers  

ADO and ADO.NET differences?

3 Answers   Microsoft,

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,