Is there a way that I can instal MSDE from within my application ? Like the user inserts the CD and it autoruns to create the instance on the user's computer without the user knowing it (like hiding it from the user) ?
Depending on what application/installation package you're installing it with etc. it isn't too difficult. This link for deploying Access based apps with MSDE might be useful.