What happens when u try to update data in a dataset in .NET
while the record is already deleted in SQL SERVER as backend?
- 5 Answers
- 12238 Views
- I also Faced
- E-Mail Answers
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
Which is better ole db or odbc?
What does datareader object do?
What are the different row versions available in table?
What is the DataTableCollection?
Which ado.net object is very fast in getting data from the database?
What is the difference between the clone() and copy() methods of the dataset class?
What is the difference between OLEDB Provider and SqlClient?
Define executenonquery?
Can we load multiple tables in a dataset?
What are the benefits of using of ADO.NET in .NET 4.0?
How is it possible to get 2 tables of data at a time by using data reader?
What is the difference between Dataset. clone and Dataset.copy?
What is the meaning of executenonquery?
How can we add relation between tables in a dataset?
What is variable view?
