simple way to insert new ms access record and return autoid value

[olafmol]

Hello,

i am wondering if there is a simple way to insert a new record into an MS
Access db and read out the newly created auto-ID field. Using ASP this was
rather simple, but in ASP.NET (VB) it seems to have become rather
complex????

cheers, Olaf

[Mary Chipman [MSFT]]

See the following KB article:
HOW TO: Retrieve the Identity Value While Inserting Records into
Access Database By Using Visual Basic .NET
http://support.microsoft.com/default...b;en-us;815629

--Mary

On Mon, 21 Feb 2005 18:14:47 +0100, "olafmol" <ol**@expansion s.nl>
wrote:

Hello,

i am wondering if there is a simple way to insert a new record into an MS
Access db and read out the newly created auto-ID field. Using ASP this was
rather simple, but in ASP.NET (VB) it seems to have become rather
complex????

cheers, Olaf

[Elton Wang]

Hi Olaf,

To insert a record

In ADO:
Dim conn As New ADODB.Connectio n
conn.Open connextString
conn.Execute insertSql
conn.Close
Set conn = Nothing

In ADO.NET
Dim conn As New OleDbConnection (connectionStri ng)
conn.Open()
Dim command As OleDbCommand = conn.CreateComm and()
command.Command Type = CommandType.Tex t
command.Command Text = insertSql
command.Execute NonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotm ail.com

-----Original Message-----
Hello,

i am wondering if there is a simple way to insert a new record into an MSAccess db and read out the newly created auto-ID field. Using ASP this wasrather simple, but in ASP.NET (VB) it seems to have become rathercomplex????

cheers, Olaf
.

[olafmol]

Hello Elton,

not much, but where do you read the autonumber value of the newly inserted
record?

cheers, Olaf

Elton Wang <an*******@disc ussions.microso ft.com> wrote in message
news:0a******** *************** *****@phx.gbl.. .

Hi Olaf,

To insert a record

In ADO:
Dim conn As New ADODB.Connectio n
conn.Open connextString
conn.Execute insertSql
conn.Close
Set conn = Nothing

In ADO.NET
Dim conn As New OleDbConnection (connectionStri ng)
conn.Open()
Dim command As OleDbCommand = conn.CreateComm and()
command.Command Type = CommandType.Tex t
command.Command Text = insertSql
command.Execute NonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotm ail.com

-----Original Message-----
Hello,

i am wondering if there is a simple way to insert a new

record into an MS

Access db and read out the newly created auto-ID field.

Using ASP this was

rather simple, but in ASP.NET (VB) it seems to have

become rather

complex????

cheers, Olaf
.

[Elton Wang]

You can try

After
command.Execute NonQuery()

command.Command Text = "SELECT @@IDENTITY"
Dim obj As Object
Dim autoNum As Integer
obj = command.Execute Scalar()
If not obj Is Nothing Then
autoNum = Integer.Parse(o bj)
End If
HTH

Elton

-----Original Message-----
Hello Elton,

not much, but where do you read the autonumber value of the newly insertedrecord?

cheers, Olaf

Elton Wang <an*******@disc ussions.microso ft.com> wrote in messagenews:0a******* *************** ******@phx.gbl. ..

Hi Olaf,

To insert a record

In ADO:
Dim conn As New ADODB.Connectio n
conn.Open connextString
conn.Execute insertSql
conn.Close
Set conn = Nothing

In ADO.NET
Dim conn As New OleDbConnection (connectionStri ng)
conn.Open()
Dim command As OleDbCommand = conn.CreateComm and()
command.Command Type = CommandType.Tex t
command.Command Text = insertSql
command.Execute NonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotm ail.com

>-----Original Message-----
>Hello,
>
>i am wondering if there is a simple way to insert a new

record into an MS

>Access db and read out the newly created auto-ID field.

Using ASP this was

>rather simple, but in ASP.NET (VB) it seems to have

become rather

>complex????
>
>cheers, Olaf
>
>
>.
>

.