SQL update current ID of record?

Hi,

I have a sript that updates a raw in my database, but after selected raw is updated I need to now ID of that raw, please help, my code is like this:

Dim connectionString As String = WebConfigurationManager.ConnectionStrings("dbDatabase").ConnectionString
Dim updateSQL As String = "UPDATE tblUsers SET LEVET=@LEVEL WHERE CODE = '" & strCode & " '"
Dim con As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(updateSQL, con)

cmd.Parameters.AddWithValue("@LEVEL", 5)Dim added As Integer = 0

Try
con.Open()
added = cmd.ExecuteNonQuery()

Response.Redirect("~\korisnicka_stranica.aspx")
Catch err As Exception
lblError.Text &= "Error inserting record. (subAdd)"
lblError.Text &= err.Message
Finally
con.Close()
End Try

Re: SQL update current ID of record?

write one more select statement like 'select Id from tblUsers where CODe = strCode'...that will return you ID...and then you can use ExecuteScalar to catch the ID in C# - http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx

Thanks,