You might get started by reading through Embedding SQL Server Express into Custom Applications.

Some people also recommend using Microsoft Component Installer Software Development Kit for Windows (x86) Version 2.0 for assisting in this.

Note that SQL Server Express 2005 is being sunsetted. SQL Server 2008 Express.