What happens when u try to update data in a dataset in .NET
while the record is already deleted in SQL SERVER as backend?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rahul
no error happened because data set is totaly worked in
discontecd form.it will unaware of changes happened in the
backend.
but if we are trying to update original database using data
set then SQLException will be thrown
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / sabir
it thorgh the execption that the object is not available
Is This Answer Correct ? | 5 Yes | 4 No |
What is ado.net connection?
How do you merge 2 datasets into the third dataset in a simple manner?
What is sequence of code in retrieving data from database ?
3 Answers Accenture, BirlaSoft,
What is a data control clerk?
How would you connect to a database by using .NET?
Differentiate between Dataset and Recordset.
What is the use of SqlCommandBuilder?
Explain what are the steps to connect to a database?
Explain the dataadapter class in ado.net?
What are all the different authentication techniques used to connect to MS SQL Server?
can u tell me the how to get the print for the form
What is microsoft ole db provider for sql server?