OleDbAdapter.InsertCommand and autoincrement IDs problem

[Guest]

I use OleDbAdapter to fill my dataset from Access database and tables with autoincrement id columns.Also i created xsd schema for my dataset

The problem is that the dataset automatically add neu unique ID which is not correspond to realy added record ID in the database
For exp. in database i have
ID Name Titl
10 john some tex
12 peter .......


ds.Table1Row newrow=ds.Table1.NewTable1Row(
newRow.Name = some name
newRow.Title = some new title
..
ds.Table1.AddTable1Row(newRow)
oledbAdapter1.Update(ds.Table1)
In this moment Dataset automatically add ID = 13 for the new record, which is not correct, in case some others records are deleted before in database after record with ID 12
My question is it possible to write InsertCommand like in SqlAdapter insert command
in one sentence Insert and Select clause included select @@IDENTITY and returns correct ID
Thanks for any help.

 

[Guest]

Until now i didn't receive an answer of my question, how to resolve incorrect autoincrement data in disconected dataset when it is MSAccess database . Fortunatlly I find the answer myself.
If someone has the same problem, please look on http://www.codeproject.com/cs/database/relationaladonet.as