Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing

Hi Mike,

You can add ta.Connection.Open before ta.Insert(this._lastName,
this._firstName);, so that the connection can be kept open, and the
@@IDENTITY can be returned. Make sure you call ta.Connection.Close() after
you get the identity.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Re: Wasnt me
    ... > That explains your posting name nicely. ... you are the first person to make the connection. ... shoddily made knock-off Jim'll Fix It badge? ... Prev by Date: ...
    (uk.rec.cars.modifications)
  • Re: Deleting datacolumns
    ... DataTable.Columns.Remove takes the column name or column reference as ... Kevin Yu ... "This posting is provided "AS IS" with no warranties, ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: DbDataReader.Read() result
    ... which mean EOF. ... Kevin Yu ... "This posting is provided "AS IS" with no warranties, ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection pool close timeout
    ... Hi Kevin, ... the default value for the connection lifetime is '0'. ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: F/T HUO Shadow
    ... Kevin and John...Thanks for posting about the machine. ... Prev by Date: ...
    (rec.games.pinball)