Once you update the recordset to MySQLi you will have to apply the MySQLi Sort server behavior to add back the sorts and apply the MySQLi Search to redo the search. It looks like you only updated the recordset so far.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.