How to attach db with exe?

Question

0.00/5 (No votes)

See more:

I create a image store application for store image in db. its work on correctly.
How to attach db with exe for use on any computer??

What I have tried:

how to attach db with exe for any use on any computer?

Posted 28-Feb-16 22:20pm

Arslan saif

Updated 28-Feb-16 22:52pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*dan!sh* · Accepted Answer · 2016-02-28T22:44:00

Solution 1

You can ship the MDF file along with application executable. Your set up project should check for SQLExpress and if not present should install it. Then, it should also copy the MDF file at desired location. The connection string should be like this:

C#

Server=.\SQLExpress;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;Database=dbname;
Trusted_Connection=Yes;

Posted 28-Feb-16 22:44pm

dan!sh

Comments

Arslan saif 29-Feb-16 4:47am

sorry but I cant understand what you say

dan!sh 29-Feb-16 4:49am

Which part? Your set up should include: application executable, MDF file for database, SQLExpress setup. Your connection string in code should be like one above.

Rishikesh_Singh · Accepted Answer · 2016-02-28T22:52:00

What db are you using? If you are using SQL CE db / or mdb then you can deploy with your executable directly, alternatively you may choose to create installer and deploy the database along with the executable in the installer directory.
If you are using mdf then you need to be sure that the client has sql server installed else you need to include the sqlserver installer along with your application installer.