Re: how to get the new identity ID just after insert a new row?

[Phil Winstanley [Microsoft MVP ASP.NET]]

Quentin,

You'll need to use SCOPE_IDENTITY() (SQL Server) or SELECT @@IDENTITY
(SQL Server and Access) at the end of your INSERT Statement, as so: -

INSERT INTO .............; SELECT SCOPE_IDENTITY();

Hth,
Phil Winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.com

 

[Quentin Huo]

Thanks for quick reply!

Do I need to change any code ?



strng sql = "INSERT INTO .............; SELECT SCOPE_IDENTITY();";


OleDbConnection conn = new OleDbConnection();


conn.ConnectionString = Session["oleconn"].ToString();

conn.Open();


OleDbCommand cmd = new OleDbCommand(sql,conn);

int nNoAdded = cmd.ExecuteNonQuery();



Here nNoAdded will be the ID? Just make sure.

Q.