Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 the functionality of data provider in ado.net?

944


What is data relation?

927


What is difference between connected and disconnected architecture in ado.net?

1158


Compare Data Reader & Dataset in ado.net?

1009


What is untyped dataset?

1095


What is disconnected data?

1050


What are the benefits of ADO.NET?

1122


What is the difference between OLEDB Provider and SqlClient?

991


Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1117


Which is better ole db or odbc?

913


What is Dataset Object?

1012


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

873


Explain the difference between data reader and data set?

931


How does ado.net work?

936


Explain the difference between sqlcommand object and command behavior object?

1095