>I work with ADO and because the DE works with ADO OLE DB, I think it's the convenient way of doing data manipulation. Ofcourse, I also tried doing it hardcoded but the big question is, why do it that way? ...

Depends on how scalable you want your application to be. Forget about the DE if you are going to build an app with more than two tiers.