very slow updata after column added

[Rod]

I have a dataset which originally came from an Access table.

I then add a column using code to the table in the dataset and fill it with
data. (About 1000 records) . The column is not in the original Access table.

all works fine except

when I come to update the Access table (using the data adapter created by
the wizard) it takes 40 seconds or more.

I don't want the data in that column so I tried removing it before doing the
update, but it made no difference.

I am sure if I added the column to the Access table all would work fine, but
as I am learning I would like to do it without fudges!
many thanks in advance

Rod

[Cor Ligthert]

Rod,

I dont know your program sequence, however I think you start with adding
that column.
Can you try it with directly after the adding of that column.

\\\
mydatatable.AcceptChanges for C# with than ();
///
For this kind of purposes that acceptchanges is made it set all rowstates to
unchanged.

I never tried it, so I am curious for the result?

I hope it helps

Cor

[Rod]

10 out of 10!
It worked.

I tried an experiment (without added columns or AcceptChanges) that changed
all the data in one column, then updated the Access table.
Again it was very slow. Is this normal? A 1000 records is a very small
database.

thanks for your help, now I'll have my combo box sorted out.

"Cor Ligthert" <no************@planet.nl> wrote in message
news:eX**************@tk2msftngp13.phx.gbl...

Rod,

I dont know your program sequence, however I think you start with adding
that column.
Can you try it with directly after the adding of that column.

\\\
mydatatable.AcceptChanges for C# with than ();
///
For this kind of purposes that acceptchanges is made it set all rowstates to unchanged.

I never tried it, so I am curious for the result?

I hope it helps

Cor