Re: DataGridView bound to TypedDataSet - Update causes Concurrency Violation
- From: "RobinS" <RobinS@xxxxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 22:21:49 -0800
From Brian Noyes' data binding book:
If you have made any changes to the rows in your data set and call
AcceptChanges, the original values for all modified rows will be
replaced with the current values, and the state of all rows will
be set to Unchanged.
You should be aware when using these methods, however, that you
generally want to avoid using them if the data in the data set
will be used to update a database through a data adapter.
The data adapter figures out which commands to execute (update,
insert or delete) for which rows based on their row state.
Rows with a row state of Unchanged don't get any command
executed against them when performing an update.
Instead of calling AcceptChanges, why don't you update the
dataset through the data adapter? I think this would write
the data to the underlying database, and update your dataset
at the same time.
That's my two cents' worth. Hope it helps.
Robin S.
---------------------------------
<rmgalante@xxxxxxxxxxxx> wrote in message
news:1164836106.630426.154370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a Windows Forms Application with a DataGridView which is bound
to a typed DataSet. For reasons specific to the application, I add a
record to the database table when a button is clicked on the form. This
button creates a record with default values so the user only has to
change what they do want as defaults.
During the add logic, I programmatically add a row to the typed DataSet
view with the AddMyTableNameRow method. This works. I call the row's
AcceptChanges(). Then I attempt to refresh the DataGridView with the
Refresh() command.
The problem I have is, when I edit one of the rows in the DataGridView
and call the update command, I get the Concurrency violation. The
UpdateCommand affected 0 of the expected 1 rows.
However, if I Fill the adapter after I add a record, then edit a row,
and call the update command, I do not get the Concurrency violation.
This leads me to believe that the grid is not synchronized with the
underlying table after I add a row, and the concurrency violation is
one of those error messages that means "alot of different things could
have caused the problem."
So how do I add a row to the underlying dataset, and make sure the
datagridview is synchronized with the underlying dataset, so that
subsequent updates do not fail?
Thanks.
.
- References:
- Prev by Date: Re: Why does insert command not work in a transaction?
- Next by Date: Re: Generate a database from XSD?
- Previous by thread: Re: DataGridView bound to TypedDataSet - Update causes Concurrency Violation
- Next by thread: Re: DataGridView bound to TypedDataSet - Update causes Concurrency Violation
- Index(es):
Relevant Pages
|
