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

From: v-kevy@xxxxxxxxxxxxxxxxxxxx (Kevin Yu [MSFT])
Date: Fri, 27 Jan 2006 03:16:58 GMT

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."

.

References:
- Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
  - From: Frank Hickman [MVP]
- Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
  - From: Frank Hickman [MVP]
- Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
  - From: Michael Slattery

Prev by Date: Re: ADO Excel connection string reference documentation
Next by Date: ADO/ASP timeout issue
Previous by thread: Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
Next by thread: Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
Index(es):
- Date
- Thread

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)