Hi

I wish to use a jet data base with an autoincrement field. How do you update
the database with the new rows added to the dataset and get the new
autoincrement number allocated by the db without refreshing the whole
dataset?

Many thanks

Julian

Hi Julian,

You can try this

da.update(ds)
da.MissingSchemaAction = MissingSchemaAction.AddWithKey
da.Fill(ds)

Cor

Check out Bill Vaugn's article on Managing an @@Identity Crisis
http://www.betav.com/msdn_magazine.htm (It's geared to SQL Server but the
same principle applies). You don't have to fire a Refresh for the whole
dataset, but each of the items you update, you'll need a SELECT command at
the end of it to get the values back. Remember to set the autoincrement
value to -1 and the seed to 0 so that you don't write the same values if
multiple users are running the app. In the DataAdapterConfiguration Wizard,
there's an option Refresh Dataset that will write the Update Statement for
you...even if you are rolling your own logic, it's a good way to see how
this works.

HTH,

Bill
"Julian" <(E-Mail Removed)> wrote in message
news:c3a8l9$cfs$(E-Mail Removed)...
> Hi
>
> I wish to use a jet data base with an autoincrement field. How do you
update
> the database with the new rows added to the dataset and get the new
> autoincrement number allocated by the db without refreshing the whole
> dataset?
>
> Many thanks
>
> Julian
>
>

On Wed, 17 Mar 2004 19:24:26 -0000, "Julian" <(E-Mail Removed)> wrote:

¤ Hi
¤
¤ I wish to use a jet data base with an autoincrement field. How do you update
¤ the database with the new rows added to the dataset and get the new
¤ autoincrement number allocated by the db without refreshing the whole
¤ dataset?
¤

If you have a Jet 4.0 database (Access 2000 or higher) see the following:

http://msdn.microsoft.com/library/de...mberValues.asp


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)