asp.net +VB: get autonumber id

[denis]

hello guys
I'm a novice for Asp.net, since now I've always used asp

I need to insert a record in an access database and get the last id of an
autonumber field

Can you please help me?
thanks

[Cor Ligthert]

Denis,

This is not an easy to answer question, maybe you can have a look what is
written in the newsgroup adonet for that.

I did a search for you.
http://tinyurl.com/6fa25

I hope this helps?

Cor

"denis" <de***@discussions.microsoft.com>

hello guys
I'm a novice for Asp.net, since now I've always used asp

I need to insert a record in an access database and get the last id of an
autonumber field

Can you please help me?
thanks

[John Timney \(ASP.NET MVP\)]

The easiest way is to insert a unique value into the table along with the
record your storing, and then do a select to get the ID based on that unique
value as the where part of the query. DataTime TickCount is normally a
suitable value.

Its two calls as opposed to one, but its a very easy to implement solution.

--
Regards

John Timney
ASP.NET MVP

"denis" <de***@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com...

hello guys
I'm a novice for Asp.net, since now I've always used asp

I need to insert a record in an access database and get the last id of an
autonumber field

Can you please help me?
thanks

[Cor Ligthert]

Dennis,

I saw yesterday (long after that I had answered your question) that there
are now nice SQL pages on MSDN.

Your question.

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

I hope this helps?

Cor

"denis" <de***@discussions.microsoft.com>

hello guys
I'm a novice for Asp.net, since now I've always used asp

I need to insert a record in an access database and get the last id of an
autonumber field

Can you please help me?
thanks