TableAdapters.Update()

[Chris Lim]

I'm new to VS 2005 (actually .NET in general) and have just been
playing with some simple forms to access/update data in a SQL Server
database.

I have a DataGridView on the form and am currently writing changes back
to the db using the Update() method of the TableAdapter. This seems to
work fine, except I want the application to behave such that if errors
occur on any row then it rolls back all the changes (e.g. if 5 rows are
updated and 1 of them fails, it should roll back changes to all 5
rows).

Is there anything built-in to handle this, or would I have to manually
add transaction handling surrounding the Update()?

[Jake K]

You will have to build the transaction as part of your .net code or use a
SQL stored procedure and transaction code (begin, commit, rollback).
"Chris Lim" <bl********@hotmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...

I'm new to VS 2005 (actually .NET in general) and have just been
playing with some simple forms to access/update data in a SQL Server
database.

I have a DataGridView on the form and am currently writing changes back
to the db using the Update() method of the TableAdapter. This seems to
work fine, except I want the application to behave such that if errors
occur on any row then it rolls back all the changes (e.g. if 5 rows are
updated and 1 of them fails, it should roll back changes to all 5
rows).

Is there anything built-in to handle this, or would I have to manually
add transaction handling surrounding the Update()?

[chanmm]

Take a look at this:
http://msdn2.microsoft.com/en-us/ms973865.aspx

chanmm

"Chris Lim" <bl********@hotmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...

I'm new to VS 2005 (actually .NET in general) and have just been
playing with some simple forms to access/update data in a SQL Server
database.

I have a DataGridView on the form and am currently writing changes back
to the db using the Update() method of the TableAdapter. This seems to
work fine, except I want the application to behave such that if errors
occur on any row then it rolls back all the changes (e.g. if 5 rows are
updated and 1 of them fails, it should roll back changes to all 5
rows).

Is there anything built-in to handle this, or would I have to manually
add transaction handling surrounding the Update()?