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
Answers were Sorted based on User's Feedback
Answer / rumpa
By using Data Adapter Update(DataSet,DataTable)
|Is This Answer Correct ?||21 Yes||6 No|
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|
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|
Answer / venu
Ya dataset have drawback.it is not updated in database
automatically.we have to use
At this time only update the table in your database.
|Is This Answer Correct ?||4 Yes||3 No|
Answer / neha
DataAdapter helps in updating back the database through its
update method. That is,
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|
Answer / kishore
we can update it by using fill();
|Is This Answer Correct ?||3 Yes||14 No|
What is typed dataset ?
What is different between sqlcommand object and command behavior object?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
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 28 can datareader hold data from multiple tables?
What happens when we issue Dataset.ReadXml command?
What are the advantages and drawbacks of using ado.net?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Explain what is datagrid with an example?
What are the Different layers in ADO.Net?
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells.Controls; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();
WHAT Are the major major compnents of a data provider in ADO.net.
How can we load multiple tables in a dataset?