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**@expansions.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.Connection
conn.Open connextString
conn.Execute insertSql
conn.Close
Set conn = Nothing

In ADO.NET
Dim conn As New OleDbConnection(connectionString)
conn.Open()
Dim command As OleDbCommand = conn.CreateCommand()
command.CommandType = CommandType.Text
command.CommandText = insertSql
command.ExecuteNonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotmail.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*******@discussions.microsoft.com> wrote in message
news:0a****************************@phx.gbl...

Hi Olaf,

To insert a record

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

In ADO.NET
Dim conn As New OleDbConnection(connectionString)
conn.Open()
Dim command As OleDbCommand = conn.CreateCommand()
command.CommandType = CommandType.Text
command.CommandText = insertSql
command.ExecuteNonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotmail.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.ExecuteNonQuery()

command.CommandText = "SELECT @@IDENTITY"
Dim obj As Object
Dim autoNum As Integer
obj = command.ExecuteScalar()
If not obj Is Nothing Then
autoNum = Integer.Parse(obj)
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*******@discussions.microsoft.com> wrote in messagenews:0a****************************@phx.gbl...

Hi Olaf,

To insert a record

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

In ADO.NET
Dim conn As New OleDbConnection(connectionString)
conn.Open()
Dim command As OleDbCommand = conn.CreateCommand()
command.CommandType = CommandType.Text
command.CommandText = insertSql
command.ExecuteNonQuery()
conn.Close()

So what's big difference?

HTH

Elton Wang
el********@hotmail.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
>
>
>.
>

.