make exe file from Windows form application which is using sql database

Question

1.00/5 (2 votes)

See more:

hello again
how to make exe file from Windows form application which is using sql database.i want to install my application to another computers in a Local area network.does anybody have a complete guide for this?

Posted 5-Mar-12 13:12pm

FM7

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)

Dave Kreskowiak · Answer 1 · 2012-03-05T15:47:00

Solution 1

For making an .EXE?? You do that every single time you Build your app.

If you're talking about deploying your app, that's a different question. One which depends on the database engine you're using and where the database is going to be located.

If you really are using SQL Server, is it a seperate server install or are you using SQL Server Express, or some other edition?

Posted 5-Mar-12 15:47pm

Dave Kreskowiak

Comments

FM7 5-Mar-12 21:52pm

use sql server,and need to make an exe file with it dependencies such as DB and framwork to instal it to another PC

Dave Kreskowiak 5-Mar-12 22:29pm

If you're using SQL Server (any NON EXPRESS edition) then you don't include the installation of SQL Server. You just come up with a script that creates your database on the SQL Server. Of course, the user will have to supply credentials to use with the SQL Server in order to run the script on it.

Next, you just create an installer for your project. If you're using a non-Express edition of Visual Studio, there's a Setup and Deployment project you can add to your solution to package up your app. Go to the File menu and select Add -> New Project -> Other Project Types.

Charlemagne Gustilo · Answer 2 · 2012-03-05T15:58:00

Solution 2

Hi,
You can try adding a form which logs in to your SQL database and then saves the login info to your registry or text file. These info will then be read by your application whenever your program starts. You will need the SQL Client installed to computers where your program will be installed. Hope this helps.

Posted 5-Mar-12 15:58pm

Charlemagne Gustilo

Comments

Dave Kreskowiak 5-Mar-12 22:29pm

What does this have to do with packaging and deploying the project to another machine??

Charlemagne Gustilo 5-Mar-12 22:38pm

Oh hi Dave! thanks for correcting me. I forgot to mention how to build the exe. I focused only on how to create a program to connect to a database. As you have mentioned, we can create a new setup and deployment project, or by right-clicking the project -> properties -> publish tab -> publish wizard button. Thanks Dave!