Loading

How to create a combine setup of windows application and sql

aman gandhi

15y2.2k.NET

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........

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge15y ago
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 Bhensdadia15y ago
Hi, you can add prerequisites while making setup of windows application.

You can add Sql Server Express Edition from that.