retriving autoincrement value after insert command

[Mauro Gagna]

hi, i have a table with customers and the customer ID is an
autoincrement field in SQLServer 2000.

I'm using this code (small version of the real code) to do an insert
into this table

OleDbConnection conn = ConnectToDataBase(); // Call to my DB
connection funtion
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "INSERT INTO customers (name, phone) values
(@strName, @strPhone)";
cmd.Parameters.Add("@name", "john");
cmd.Parameters.Add("@phone", "555-0002");
cmd.ExecuteNonQuery();

the problem is how can i know what is the customer ID that the
SQLServer assigns to this record. I have multiple users that are doing
inserts in the same time.

Thanks in advace.

Mauro Gagna
(e-mail address removed)

 

[William Ryan]

This article on MSDN should help
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp
and there have been a bunch of recent posts answered by David Sceppa and
Bill Vaughn on the subject.

HTH,

Bill