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 rdo dao in visual basic?
What do you know about ADO.NET's objects and methods?
How to creating a SqlCommand Object?
What is the meaning of object pooling?
What does datareader object do?
How do you find the count of records in a dataset?
What is the difference between a datareader and a dataset?
What are the ado.net connection pooling parameters?
How to perform sorting on a table in ADO.NET?
how can implement dropdownlist in particular of dataset when try to update?
What is a sqldataadapter?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Compare Data Reader & Dataset in ado.net?
Which provider is used to connect ms access, oracle, etc…?
What do you know about ado.net's methods?