I am getting more and more frustrated with this.

foreach (DataGridViewRow row in venuesDataGridView.Rows)
{
myDataSet.VenuesRow data = (myDataSet.VenuesRow)((DataRowView)
row.DataBoundItem).Row;
... skip some...

data.BeginEdit();

if( data.IsNull("End1") )
{
data.End1 = ScoreVenue["NorthernEnd"].ToString();
}
if (data.IsNull("End2"))
{
data.End2 = ScoreVenue["SouthernEnd"].ToString();
}
data.EndEdit();
data.AcceptChanges(); / figure this commits but it does not!!!
... more code ...
}

And what I figure 'should' commit without data.?edit commands and
data.acceptchanges.

private void EndEditOnAllBindingSources()
{
var BindingSourcesQuery =
from Component bindingSources in
this.components.Components
where bindingSources is BindingSource
select bindingSources;

foreach (BindingSource bindingSource in BindingSourcesQuery)
{
bindingSource.EndEdit();
}
}

private void UpdateDatabase()
{
Validate();

EndEditOnAllBindingSources();

myAdapterManager.UpdateAll(myDataSet); // hierarchy is set
correctly.

myDataSet.AcceptChanges(); // this should not be needed.
}


I cannot get my data that is written by program into the table back onto
disk which is an access table.

Thanks
Ken

AcceptChanges says "this object doesn't need updating", which is the
exact opposite of what you want. Try removing this line.

Marc

On Mon, 07 Jul 2008 15:51:51 +0100, Marc Gravell wrote:

> AcceptChanges says "this object doesn't need updating", which is the
> exact opposite of what you want. Try removing this line.

OK I totally misread that one. I now have data writing back.

Ta
Ken

On Tue, 08 Jul 2008 01:02:59 +1000, Ken Foskey wrote:

> On Mon, 07 Jul 2008 15:51:51 +0100, Marc Gravell wrote:
>
>> AcceptChanges says "this object doesn't need updating", which is the
>> exact opposite of what you want. Try removing this line.
>
> OK I totally misread that one. I now have data writing back.

OK it works in one application and not another. The only difference that
I can see is that the one that is working has a navigator in it and I
deleted it out of the second. Is there something that the navigator does?

Ta
Ken

I found the problem, it is all working now.

Thanks for your help
Ken