What happens when u try to update data in a dataset in .NET
while the record is already deleted in SQL SERVER as backend?
Answer Posted / vaidyanathan r.
If the updating is done in DataSet then there will be no
error. It will work fine. Because Dataset is totally
disconnected from the Database and unaware of changes
happened in the backend. The user is free to update the
dataset.
Once the changed data is updated in the database(backend)
then an SQLException will be thrown.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is the functionality of data provider in ado.net?
What is data relation?
What is difference between connected and disconnected architecture in ado.net?
Compare Data Reader & Dataset in ado.net?
What is untyped dataset?
What is disconnected data?
What are the benefits of ADO.NET?
What is the difference between OLEDB Provider and SqlClient?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Which is better ole db or odbc?
What is Dataset Object?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain the difference between data reader and data set?
How does ado.net work?
Explain the difference between sqlcommand object and command behavior object?