How to create a combine setup of windows application and sql

Question

i have completed with a windows application in which i am using sql database.
now i want to create a setup for this but i want when user instal my application Mssql will automatically install on user's system. how can i perform this.

i want my database should also get stored on that system.

Thanks

Aman Gandhi
comman sense is not so comman........

Pravin Ghadge · Answer

Hello aman Plz try Himanshu solution. After the installation of setup u want database should be automatically attach to sql. for that u have to change ur connection string as follows: Conn.ConnectionString = Data source=ServerName';integrated security=true;AttachDBFilename=|DataDirectory|Databasename.mdf;User Instance=True Regards Pravin

Himanshu Bhensdadia · Answer

Hi you can add prerequisites while making setup of windows application. You can add Sql Server Express Edition from that.