get the record id after inserting

[ghassan_aljabiri]

hello

I use this code to insert a record to a table

CustodiesTableAdapter.InsertQuery(cname, Now.Date, 0, cnotes, eid)

the record contains an autonumber field (cid)

i need this value after inserting

I used this code

CustodiesBindingSource.MoveLast()
Dim cid As Long = CLng(DirectCast(CustodiesBindingSource.Current, DataRowView)("cid"))

but it returns the id of the last record before adding the new one

how to get the right value

Regards

 

[ggunter]

Since it's an autonumber, wouldn't it be (the last record id + 1)?

 

[cjard]

If the parameter was declared as inputoutput or output then you'd have to pass it ByRef and it would contain the calcualted value when Insertuery finishes... But tyically you wouldnt use this, you'd just use a dataset and tableadapter configured to "refresh the dataset" (advanced options)

 

[ghassan_aljabiri]

unfortunatly
this advanced option is not enabled for Access Data Bases

 

[kulrom]

If i remember well MS Access supports select @@identity syntax !? Does it?

If it was SQL Server you would probably want to use SCOPE_IDENTITY() but i am not sure if Access supports it.

 

[cjard]

unfortunatly
this advanced option is not enabled for Access Data Bases

I think, then, you need a more advanced database

Retrieving Identity or Autonumber Values (ADO.NET)