very slow updata after column added

  • Thread starter Thread starter Rod
  • Start date Start date
R

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
 
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
 
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.
 
Back
Top