When you inserting data using SqlCommandBuilder...

[Rico Alexander]

is there a way to retrieve the value of an autoincrement column inserted in
the database?

[zPaul]

Re: When you inserting data using SqlCommandBuild er...

Select @@Identity right after the insert. You will get the autoincrement
value.


"Rico Alexander" <ralexand@ucla. edu> wrote in message
news:OX7GDqamDH A.2772@TK2MSFTN GP12.phx.gbl...[color=blue]
> is there a way to retrieve the value of an autoincrement column inserted[/color]
in[color=blue]
> the database?
>
>[/color]