Window Application:
It has rich GUI and to be installed specifically in a machine for execution. But this drawback is resolved using click once deployement in VS2005.

Web application:
It will be exposed over intra or internet and can be accessed via URL.

Both has the capability to use Databases
Regards,
Venkatesan Prabu. J