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


Please Help Members By Posting Answers For Below Questions

What is sqldatareader in ado.net?

497


Explain how to find the given query is optimised one or not?

509


What is the difference between the clone() and copy() methods of the dataset class?

540


Define the executescalar method?

511


What is isolation?

562






What is untyped dataset?

539


What is data reader in ado.net?

497


What does executenonquery () method return?

498


What is ole2 format?

499


Why edit is not possible in repeater?

515


How can we save all data from dataset?

533


What is typed dataset ?

671


What is data view and variable view?

479


What are the major difference between classic ADO and ADO.NET?

511


What are all features of ADO.Net?

544