adding sql database to a publish folder with C#

Question

0.00/5 (No votes)

See more:

hi guys, i'm working on a software that uses an sql database. I'm trying to create an installer with the publish utility of visual studio 2008 so that i can install the software on other computers. My problem is that whenever i use the publish to create the installer, it doesn't add the sql database that the software needs to run properly. please can anyone give me a hint on how to make it work right.
thankz

Posted 27-Sep-11 3:00am

xlboyz

Add a Solution

Comments

Kschuler 27-Sep-11 10:46am

How are you publishing it? ClickOnce? Setup Project? Other?

3 solutions

Solution 1

Hello Friend..

If you can Use a Setup Project, then you can add a your database file to your application folder to copy that file at your installation directory..

application.startuppath is method to get the path from where your application or project .exe file will run
then for connection string you can use a application.startuppath to get the custom path of your database

using this you can add the database to your setup file..

or please specify the type which you deploy for your project like
publishing it? ClickOnce? Setup Project? Other? as Kschuler says..

Posted 27-Sep-11 20:15pm

Tejas Vaishnav

Solution 2

hi guys,
i'm publishing the project with Visual studio 2008 in built publishing tool.
I don't know if there is any other means of creating an installer for programs designed in C#. if there is please let me know.
Tejas_Vaishnav, i don't know how to use setup project. id appreciate it if you can put me through on how to use it with easy key points.
thanks

Posted 28-Sep-11 5:06am

xlboyz

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)

Pradeep Shukla · Accepted Answer · 2011-09-28T05:26:00

There is no option for adding an additional file if you use publish method as it's a default mechanism for publishing when you want to release a setup with the existing project. Please find the link to create a setup project manually which would let you add the additional sql db file to your setup.

http://vijirajkumar.blogspot.com/2010/03/create-setup-and-deployment-project.html[^]