You will find the MySQLi code is much cleaner, more concise, and easier to read and work with in code view.
Also, if you have an existing page with an existing recordset, just open it from the Server Behaviors panel and switch it to a MySQLi connection and the code on the page will be updated automatically so you don't have to re-apply the recordset to update it.