Getting Key Just Entered

************* Edited by moderator Adec ***************


Inserted missing < code></ code> tags (without the


spaces inside). Always include such tags when


including code in your postings. Don't force the


moderators to do this for you. Many readers disregard


postings without the code tags.


**************************************************





Hi





Probably a dumb question but I'm doing an insert into a table with an identity field. How do I get the key back straight after I add it?





This is how I do the addition





SQLString = "Insert into users (username,password,status,campus, ulevel ) values ( @username, @password, @status, @campus, @ulevel)"


cmdInsert = new SQLCommand(SQLString, conn)


cmdInsert.Parameters.Add( "@username", _username)


cmdInsert.Parameters.Add( "@password", md5Hasher.ComputeHash(encoder.GetBytes(_password)))


cmdInsert.Parameters.Add( "@status", _status)


cmdInsert.Parameters.Add( "@campus", _campus)


cmdInsert.Parameters.Add( "@ulevel", _ulevel )


conn.Open()


cmdInsert.ExecuteNonQuery()


conn.close()





but about now I need the primary key just generated.


Any ideas?





Thanks


ABold