Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12517 Views
- Accenture, FastStream, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
da.update(dataset_object,Table_name);
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,
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are disadvantages of microsoft-provided data provider classes in ado.net?
FetCh Records No 5 to 10 From Dataset
Some important instruction regarding ADO.NET connection string ?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is ole in excel?
Define the executescalar method?
What is two way data binding android?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
How is entity framework different from ado.net?
What is Dataset Object?
What are the Data providers in ADO.Net?
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
