Dataset

[Victor Rodriguez]

How after creating a new row on a table that has an autoincrement column and
updating the server could I be able to get the new id created automatically
at the server?

thanks,

Victor

 

[Cor Ligthert]

Victor,

There are a lot of methods to add a row to a datast with the
autoincrementseed

Currencymanager.addnew, rowcollection.addnew, dataview.addnew

You can read this article from Bill for this.

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

I hope this helps?

Cor

 

[Guest]

Hi Victor,
Try this query
SELECT IDENT_CURRENT('TableName')

Hope this helps