ADO.NET newbie Q:Extracting MSAccess AutoNumber

[Colin Basterfield]

Hi,

I am inserting a record into an MS Access table using ADO.NET and would
really like to have a way of getting the value that has been automatically
generated by the MSAccess fieldtype "AutoNumber", but am struggling to see
how it can be done. I am using OleDbAdapter to do the insert...

Any answers/ideas/pointers would be greatly appreciated
TIA
Colin B

 

[William Ryan]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp

 

[Colin Basterfield]

Hi,

This is a really useful article, and I especially liked the first paragraph,
unfortunately I have to use JET to prove something to a client, so I'm stuck
with JET...

Many thanks for your help, I'm onto it now...
Colin B