creation of data base using sql server and connect to it

Question

2.67/5 (3 votes)

See more:

Hi everybody,
I would be glad if someone can help me with an issue.
I am planning to make a software for managing a bodybuilding gym, and for the database I am planning to make it in the laptop of the user not in a server, so the question is how can I make sure that the software will be connected to the data base after finishing it(programming in it in another laptop- this means the the soft will be coded in a machine and then move to another machine but for the database connection I guess that there will be a different String in the user laptop). will the soft conect to the databse or do I need to chane something in it.
Another thing: will the user need a dabase management system(SQL Server in my case) or not?

Posted 22-May-11 8:28am

anyavacy

Add a Solution

2 solutions

Solution 2

see here
SQL Server DO's and DONT's[^]
Beginners guide to accessing SQL Server through C#[^]
Connecting to SQL Server[^]

Posted 22-May-11 8:59am

guendouz bachir

Comments

[no name] 22-May-11 15:48pm

Accessing and using SQL Server does not appear to be the OPs problem. Installing the application and creating the database on another machine seems to be the issue.

guendouz bachir 22-May-11 16:54pm

you can do it by CORBA,DCOM,RMI ... technologies

[no name] 23-May-11 23:44pm

what are you talking about?

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)

Not Active · Accepted Answer · 2011-05-22T08:58:00

Solution 1

Although .net application can use xcopy deployment in your case creating a setup package would be the best option. This setup would also install dependencies, such as SQL Server Express, and create the required database while also setting the connection string in the app.config file.

All of this is well documented and can be found if you search for it.

Posted 22-May-11 8:58am

Not Active

Comments

CS2011 24-May-11 4:36am

Why some will downvote this. Seems good enogh to me. my 5

[no name] 24-May-11 8:43am

Because we have moronic trolls here.