I am not sure if you have the option of using sql server compact, but if so, you will find this so easy and there is a lot of useful documentation to support you.

Yes, I think the cursor.waitcursor method may work in your scenario. Windows Mobile by default should display the waiting cursor for you. Is there something specific you are doing inside of your custom app? You didn't leave a lot of details.