how to exporting a c# ands sql server project

Question

1.00/5 (1 vote)

See more:

hi i created a c sharp project with sql server as a back end. my question is how can i run that project in another system that doesn't installed c# and sql server. is there any software that make my project as software? i want to run that project without installing c# and sql server.

Posted 5-Dec-11 19:32pm

Arthesh G

Add a Solution

4 solutions

Solution 4

i made it by PUBLISH feature. it can also deploy by some third party software like install shield

Posted 7-Feb-12 21:14pm

Arthesh G

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)

**AmitGajjar** · Accepted Answer · 2011-12-05T21:35:00

Solution 3

Hi,

one work around is ,

if application is installed in any of the network computer then share that folder in your network,

now you need to create shortcut of that shared executable file and through that you can run your application without sql server and Framework.

hope i answer your query.

thanks
-Amit.

Posted 5-Dec-11 21:35pm

AmitGajjar

Comments

lilian87 5-Mar-12 9:05am

I know this is an old post.But i have a question.Where should i put my sql server 2005 database?
can I put it in shared folder?If so, what connection string should i use?Can you help me??

AmitGajjar 5-Mar-12 23:39pm

You can store your database in your App_Data folder and create installer. and share your installed folder executable file.

lilian87 6-Mar-12 0:40am

But im doing a desktop application in C#. Now the database is in my pc.I want to move it to shared folder. So what connection string should i use?
Please help..

AmitGajjar 6-Mar-12 0:44am

ok, then store your database file in any network location. then create shortcut of that network file in your pc and that database will be used by your c# application.

lilian87 6-Mar-12 1:02am

Can you help me in writing the connection string.
THe network path is \\128.1.2.128\Folder\db.mdf and db.ldf.As you said i made shortcut of it on my pc.But dont know how to write the connection sting..Please help me...

AmitGajjar 6-Mar-12 1:07am

connection string would be similar as you are writing for your local database.

lilian87 6-Mar-12 1:34am

The connection string now im using is:
public static readonly string CONN_STRING = "Data Source=MISname;Initial Catalog=XXXXdb;User ID=sa;Password=sa123;Integrated Security=True";

If im using the same string,then what is the use of copying db to a network folder? Im really confused,dats y asking such questions.. Please help..

AmitGajjar 6-Mar-12 1:38am

you do not need to use SQL server credentials, you need to use your local computer user account.

something like,
Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

you can find more connection strings on http://www.connectionstrings.com/sql-server-2008

Eduard Lu · Accepted Answer · 2011-12-05T19:35:00

Solution 1

Read this article from CodeProject:

[Host application in IIS]

Please mark as answer and vote 5 if this solved your problem

Regards,
Eduard

Posted 5-Dec-11 19:35pm

Eduard Lu

Comments

Abhi KA 6-Dec-11 2:08am

The System was outside of network.

[no name] 6-Dec-11 2:10am

what do you mean?

S V Saichandra · Accepted Answer · 2011-12-05T21:16:00

If your application is windows you need to install .net framework which will about 100mb and sql server express whihc will be about 80mb and you just need to change or configure your connectionstring for the installed sqlserver express.

Secondly

If your applicaiton is web just you can host it any server and access it from any other device or computer.

Or

You can also can host the application in IIS of your client system and you can configure as said in the above answer. You can go through the link specified in the above answer.