What happens when u try to update data in a dataset in .NET while the record is

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

What happens when u try to update data in a dataset in .NET
while the record is already deleted in SQL SERVER as backend?

Question Posted / guest

5 Answers
11445 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What happens when u try to update data in a dataset in .NET while the record is already deleted in ..

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

What happens when u try to update data in a dataset in .NET while the record is already deleted in ..

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

What happens when u try to update data in a dataset in .NET while the record is already deleted in ..

Answer / sabir

it thorgh the execption that the object is not available

Is This Answer Correct ?

5 Yes

4 No

What happens when u try to update data in a dataset in .NET while the record is already deleted in ..

Answer / vasudevan

Throws Exeption object is not availabe