Get ID back when inserting a SQL record
cmd.Parameters.Add(new SqlParameter { ParameterName = "@InsertedID", Direction = ParameterDirection.Output }); int insertedId = cmd.ExecuteNonQuery();