Mike,

For SQL Server:

SELECT ident_current('MyTable')+ident_incr('MyTable')

For a DataTable:

myDataSet.Tables("MyDataTable").Columns("MyPrimaryKeyColumn").AutoIncrementSeed + myDataSet.Tables("MyDataTable").Columns("MyPrimaryKeyColumn").AutoIncrementStep

Keep in mind that once a second connection to the SQL Server table is established, the next autoincrement number will become meaningless unless you enclose the entire data operation in a transaction.

Also, if you are using a Primary Key column in your DataTable that maps to an autoincremented field in the source database, the .NET auto-incremented values will be overwritten by the database when the row is INSERTED.

>Hi Guys,
>
>Is it possible to get the next autoincrement no. of a table before you insert a new record?
>
>Thanks....