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 ado code?
What is untyped dataset?
What is oledb driver?
What are the disadvantages of using datalist?
Which control of the BindingNavigator returns the current position within the data source?
Give an example that shows how to execute a stored procedure in ado.net?
How do you update database through dataset?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is a data control clerk?
Command objects uses, purposes and their methods.
What are the several execute methods of ado.net?
What is sqldatasource?
What is data relation in ado.net?
Explain how to create dynamic gridview?
What are the important features of ado.net 2.0?