How to Install C# Windows app with local db to client system

Hemal Joshi

Hello,

I have created small window C# application in Visual Studio 2012 which include local database in it and now i want to create setup of that application with database how to create it and after creation of the setup i will install it on client pc with database how can it run successful on client PC.

My Connection String is:

SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\admin\Documents\SerialKey.mdf;Integrated Security=True;Connect Timeout=30");

Help with Code...

3 Replies

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

Altaf Ansari8y ago
Keep Your DataBase inside the Project Directory and
Try This:
<"ConStr" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\DataBase.mdf;Integrated Security=True;Connect Timeout=30; MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />
0
Amit Gupta8y ago
You should use common path for your connection string
0
Nikunj Satasiya8y ago
Hello Hemal,

You can create your setup file (.exe) file using InstallShild. if you don't know how to create setup with InstallShild then go with Google or YouTube and search How to create exe or setup in InstallShild.

You are using LocalDB right ? So you need to install Microsoft® SQL Server® 2012 Express (LocalDB v.11.0) in your client system. Download this from this given link :
https://www.microsoft.com/en-in/download/details.aspx?id=29062 .

If you using any report in your application then you need to install crystal report viewer runtime in your client's system.
0