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

[Quentin Huo]

Hi:

I have a table which key is an identity integer ID named "readerID", so the
readerID is created by system after I insert the new record. I use the
following code to insert a new record:

strng sql = "INSERT ......";

OleDbConnection conn = new OleDbConnection();


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

conn.Open();


OleDbCommand cmd = new OleDbCommand(sql,conn);

int nNoAdded = cmd.ExecuteNonQuery();



I need to retrive the ID just after insert a new record, how can I do this?
In ASP, I don't need to use the query again. But I don't know how to do this
in ASP.NET.

Thanks

Q.

 

[Natty Gur]

Hi,

The same as you do it with ASP. if its SQL server use @@Indintity to
return the new ID. If it's oracle use MySequence.NextVal...

HTH

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)52-8888377


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[diehardguy]

How to Get New Oracle Row ID on Insert

See my post on how to return the new oracle row id in this post within the same query:

http://forums.asp.net/thread/1331466.aspx

Cheers!

Die Hard Guy