deployment in vb 2005

[anelka]

how can bundle sql express edition in to my vb app. so that sqel express edition install when i install the app

[Daxthecon]

The SQL queries in the program are referenced in the sln file and suo file. SQL is on every machine made after 2002 and the queries are excuted through the machine. If the machine doesn't have Windows XP then obviously this will be an issue that takes a further in depth look. But a InstallShield or WinWizard should take care of that issue as well.

[aishjoshi]

how can bundle sql express edition in to my vb app. so that sqel express edition install when i install the app

You can use an installation authoring tool for this purpose which will make your task easier. I would suggest you to try InstallAware which allows one click deployment of runtimes like SQL Server Express and such. This installation tool will bundle up the pre-requisites in a single click. Also, you can take advantage of its superior compression capability in which your pre-requisites will be compressed to a fraction of their original size. If your selected pre-requisite has further dependencies, InstallAware includes them for you as well - automatically.
You can even check for a named instance and install only if that named instance is not found - true to the spirit of pre-requisites. They will only be downloaded if they are not already available on the target system.