DataAdapter.Acc eptChangesDurin gUpdate not working

[George]

I have set DataAdapter.Acc eptChangesDurin gUpdate = true;

However, I find that I still need to call AcceptChanges on the associated
DataTable,

DataTable.Accep tChanges();

Has anyone encountered that? Am I not setting this field properly?

The following are some of the snippets of the codes which may help explain
what I was doing,
//Setting DataAdapter.Acc eptChangesDurin gUpdate
{
....

jobListDataAdap ter = new
System.Data.Ole Db.OleDbDataAda pter(commandStr ing, oOleDbConn);

oOleDbCommandBu ilder = new
System.Data.Ole Db.OleDbCommand Builder(jobList DataAdapter);

jobListDataTabl e = new System.Data.Dat aTable("Job List
Access DataTable");
jobListDataAdap ter.AcceptChang esDuringFill = true;
jobListDataAdap ter.AcceptChang esDuringUpdate = true;

jobListDataAdap ter.Fill(jobLis tDataTable);
....
}

Thanks,

--
George

[Marina Levit [MVP]]

You are only getting data into the table in this example. You are not
updating the database, so that property would not be relevant.

"George" <wa**@nospam.no spam> wrote in message
news:E0******** *************** ***********@mic rosoft.com...

I have set DataAdapter.Acc eptChangesDurin gUpdate = true;

However, I find that I still need to call AcceptChanges on the associated
DataTable,

DataTable.Accep tChanges();

Has anyone encountered that? Am I not setting this field properly?

The following are some of the snippets of the codes which may help explain
what I was doing,
//Setting DataAdapter.Acc eptChangesDurin gUpdate
{
...

jobListDataAdap ter = new
System.Data.Ole Db.OleDbDataAda pter(commandStr ing, oOleDbConn);

oOleDbCommandBu ilder = new
System.Data.Ole Db.OleDbCommand Builder(jobList DataAdapter);

jobListDataTabl e = new System.Data.Dat aTable("Job List
Access DataTable");
jobListDataAdap ter.AcceptChang esDuringFill = true;
jobListDataAdap ter.AcceptChang esDuringUpdate = true;

jobListDataAdap ter.Fill(jobLis tDataTable);
...
}

Thanks,

--
George

[George]

The snippet only demonstrate how I setup AcceptChangesDu ringUpdate.

Eventually, at some other location I would have call

{
....
oChangeDataTabl e = this.jobListDat aTable.GetChang es();
if (oChangeDataTab le != null)
{
this.JobListDat aAdapter.Update (oChangeDataTab le);

foreach (System.Data.Da taRow oDataRow in
oChangeDataTabl e.Rows)
{
if (oDataRow[JobDataGridView ColumnId] ==
System.DBNull.V alue)
{
this.jobListDat aTable.Clear();

this.jobListDat aAdapter.Fill(t his.jobListData Table);
break;
}
}

jobListDataTabl e.AcceptChanges ();

....
}

After Update(), the RowState of changed rows seem to be updated to
"unchanged" from "Added", "Deleted".. . and what not.

However, without specifically calling DataTable.Accep tChanges(), the next
call to DataTable.GetCh anges() still returns a table of changed rows.

Any ideas?

--
George
"Marina Levit [MVP]" wrote:

You are only getting data into the table in this example. You are not
updating the database, so that property would not be relevant.

"George" <wa**@nospam.no spam> wrote in message
news:E0******** *************** ***********@mic rosoft.com...

I have set DataAdapter.Acc eptChangesDurin gUpdate = true;

However, I find that I still need to call AcceptChanges on the associated
DataTable,

DataTable.Accep tChanges();

Has anyone encountered that? Am I not setting this field properly?

The following are some of the snippets of the codes which may help explain
what I was doing,
//Setting DataAdapter.Acc eptChangesDurin gUpdate
{
...

jobListDataAdap ter = new
System.Data.Ole Db.OleDbDataAda pter(commandStr ing, oOleDbConn);

oOleDbCommandBu ilder = new
System.Data.Ole Db.OleDbCommand Builder(jobList DataAdapter);

jobListDataTabl e = new System.Data.Dat aTable("Job List
Access DataTable");
jobListDataAdap ter.AcceptChang esDuringFill = true;
jobListDataAdap ter.AcceptChang esDuringUpdate = true;

jobListDataAdap ter.Fill(jobLis tDataTable);
...
}

Thanks,

--
George

[Marina Levit [MVP]]

Which table are you checking for the row state - jobListDataAdap ter or
oChangeDataTabl e?

"George" <wa**@nospam.no spam> wrote in message
news:14******** *************** ***********@mic rosoft.com...

The snippet only demonstrate how I setup AcceptChangesDu ringUpdate.

Eventually, at some other location I would have call

{
...
oChangeDataTabl e = this.jobListDat aTable.GetChang es();
if (oChangeDataTab le != null)
{
this.JobListDat aAdapter.Update (oChangeDataTab le);

foreach (System.Data.Da taRow oDataRow in
oChangeDataTabl e.Rows)
{
if (oDataRow[JobDataGridView ColumnId] ==
System.DBNull.V alue)
{
this.jobListDat aTable.Clear();

this.jobListDat aAdapter.Fill(t his.jobListData Table);
break;
}
}

jobListDataTabl e.AcceptChanges ();

...
}

After Update(), the RowState of changed rows seem to be updated to
"unchanged" from "Added", "Deleted".. . and what not.

However, without specifically calling DataTable.Accep tChanges(), the next
call to DataTable.GetCh anges() still returns a table of changed rows.

Any ideas?

--
George
"Marina Levit [MVP]" wrote:

You are only getting data into the table in this example. You are not
updating the database, so that property would not be relevant.

"George" <wa**@nospam.no spam> wrote in message
news:E0******** *************** ***********@mic rosoft.com...

>
> I have set DataAdapter.Acc eptChangesDurin gUpdate = true;
>
> However, I find that I still need to call AcceptChanges on the
> associated
> DataTable,
>
> DataTable.Accep tChanges();
>
> Has anyone encountered that? Am I not setting this field properly?
>
> The following are some of the snippets of the codes which may help
> explain
> what I was doing,
>
>
> //Setting DataAdapter.Acc eptChangesDurin gUpdate
> {
> ...
>
> jobListDataAdap ter = new
> System.Data.Ole Db.OleDbDataAda pter(commandStr ing, oOleDbConn);
>
> oOleDbCommandBu ilder = new
> System.Data.Ole Db.OleDbCommand Builder(jobList DataAdapter);
>
> jobListDataTabl e = new System.Data.Dat aTable("Job List
> Access DataTable");
> jobListDataAdap ter.AcceptChang esDuringFill = true;
> jobListDataAdap ter.AcceptChang esDuringUpdate = true;
>
> jobListDataAdap ter.Fill(jobLis tDataTable);
> ...
> }
>
>
>
> Thanks,
>
> --
> George

[George]

Hi Marina,

I figured out what I did wrong. I guess the reason is related to your
question as well.

I have called DataAdapter.Upd ate(oChangeData Table). I thought this will be
more efficient since it is a smaller or equal size table. However, the
AcceptChangesDu ringUpdate flag is causing oChangeDataTabl e.AccpetChanges () to
be called, while jobListDataTabl e's changes have not been accepted.

Now I changed my call to DataAdapter.Upd ate(jobListData Table) and it works
as I desired. I came across this while I was review my codes and realized
that DataAdapter does contain any reference to a particular DataTable. the
DataTable is passed into method's parameter.

Thanks for your help

--
George
"Marina Levit [MVP]" wrote:

Which table are you checking for the row state - jobListDataAdap ter or
oChangeDataTabl e?

"George" <wa**@nospam.no spam> wrote in message
news:14******** *************** ***********@mic rosoft.com...

The snippet only demonstrate how I setup AcceptChangesDu ringUpdate.

Eventually, at some other location I would have call

{
...
oChangeDataTabl e = this.jobListDat aTable.GetChang es();
if (oChangeDataTab le != null)
{
this.JobListDat aAdapter.Update (oChangeDataTab le);

foreach (System.Data.Da taRow oDataRow in
oChangeDataTabl e.Rows)
{
if (oDataRow[JobDataGridView ColumnId] ==
System.DBNull.V alue)
{
this.jobListDat aTable.Clear();

this.jobListDat aAdapter.Fill(t his.jobListData Table);
break;
}
}

jobListDataTabl e.AcceptChanges ();

...
}

After Update(), the RowState of changed rows seem to be updated to
"unchanged" from "Added", "Deleted".. . and what not.

However, without specifically calling DataTable.Accep tChanges(), the next
call to DataTable.GetCh anges() still returns a table of changed rows.

Any ideas?

--
George
"Marina Levit [MVP]" wrote:

You are only getting data into the table in this example. You are not
updating the database, so that property would not be relevant.

"George" <wa**@nospam.no spam> wrote in message
news:E0******** *************** ***********@mic rosoft.com...
>
> I have set DataAdapter.Acc eptChangesDurin gUpdate = true;
>
> However, I find that I still need to call AcceptChanges on the
> associated
> DataTable,
>
> DataTable.Accep tChanges();
>
> Has anyone encountered that? Am I not setting this field properly?
>
> The following are some of the snippets of the codes which may help
> explain
> what I was doing,
>
>
> //Setting DataAdapter.Acc eptChangesDurin gUpdate
> {
> ...
>
> jobListDataAdap ter = new
> System.Data.Ole Db.OleDbDataAda pter(commandStr ing, oOleDbConn);
>
> oOleDbCommandBu ilder = new
> System.Data.Ole Db.OleDbCommand Builder(jobList DataAdapter);
>
> jobListDataTabl e = new System.Data.Dat aTable("Job List
> Access DataTable");
> jobListDataAdap ter.AcceptChang esDuringFill = true;
> jobListDataAdap ter.AcceptChang esDuringUpdate = true;
>
> jobListDataAdap ter.Fill(jobLis tDataTable);
> ...
> }
>
>
>
> Thanks,
>
> --
> George

[Kevin Yu [MSFT]]

Hi George,

Yes, this is the case. In addition, you don't need to use GetChanges to get
the difference set to update as this will not improve performance, unless
you're passing the DataSet through a web-service.

Kevin Yu
Microsoft Online Community Support

=============== =============== =============== =============== =============== =
=============== ===========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== =============== =============== =
=============== ===========

(This posting is provided "AS IS", with no warranties, and confers no
rights.)