How to develop a windows application for multiple users?

Question

1.36/5 (3 votes)

See more:

, +

Well I am new to programming. I have developed a windows form application using visual studio 2015 and with C# language. Back end is developed with MS SQL Server Management Studio 2014. What I want is, now I want to test this system. Well assume like this. My program is used by 10 people. And they have several user levels. So the users login to the system at the same time and do their work and data get saved to the database. So I should set up a server for this right? or I should host my database online? I don't have much of a idea. Thanks :)

Posted 9-Sep-15 19:54pm

Member 11848224

Add a Solution

Comments

Sergey Alexandrovich Kryukov 10-Sep-15 2:08am

It's not clear what kind of idea you are missing. Different roles of different users is a commonplace. What exactly is the problem?
—SA

Member 11848224 10-Sep-15 2:15am

How to host this? I mean when i go and install this in 3 different PCs. They are not linked with each other. I mean they run as separate systems. So the solution is host the DB in a common place? And how to do it ?

Sergey Alexandrovich Kryukov 10-Sep-15 2:17am

It depends on what you want to achieve. Apparently, you need some online service and client-side application. Again, this is a commonplace. It could be Web service, or Web application, or some custom service, say, a WCF service. It all depends on your requirements.

Look, to ask questions productively, you need to understand what you need much better.

—SA

Sinisa Hajnal 10-Sep-15 2:33am

Or it could simply be intranet database with direct access...or even hosted database (but of course requiring internet connection).

Just google it.

2 solutions

Solution 2

If you are using SQL Server, you already have a server set up - the applications all communicate with the database via that. So for a local based solution, you have already got what you want.

You could move the DB to an online host, but there are risks associated with that: just moving the DB to a web hosting service and accessing it remotely is possible, but potentially exposes your data to anyone, not just your users and your application.
A cloud based DB could be better in that regard, but "security" and "the cloud" shouldn't really be used in the same sentence unless prefixed by "total lack of any real"...

If it's working locally, then personally I'd keep it local. It's quicker, it's safer, and it's a lot easier to back up!

Posted 9-Sep-15 20:22pm

OriginalGriff

Comments

Sinisa Hajnal 10-Sep-15 2:34am

But this is problematic if users work on the same data (as I understand the situation). You cannot have separate installations of the database on each computer.

OriginalGriff 10-Sep-15 3:51am

No, the whole idea of SQL Server (and MySQL) is that the server handles all the multi user aspects, and lets each user do what they need to without affecting other users.
You don't want separate installations of the database - never duplicate data! That's what server-based database systems are designed for!

Provided you have written your code correctly, it should just work. The only time you get problems is usually if your code tries to "get" IDs before rows are allocated - IDENTITY columns are a common source of this if you don't handle them right - but no experienced coder will try to do that anyway!

Sinisa Hajnal 10-Sep-15 7:59am

That is exactly what I was saying. I was commenting on "if its working locally" part of your solution - I understood it as locally on that particular PC.

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)

Suvendu Shekhar Giri · Accepted Answer · 2015-09-09T20:18:00

You can setup a server to host the database and then if you need your database to avaialble to the users not connected to the same network then provide it a public IP so that it can be accessed over internet. Else if the users connected to the same network then you can provide them access through the local IP too.

Then you need to configure your SQL Server to allow remote access
http://stackoverflow.com/a/11278115/1006297[^]

You also need to change the connection string accordingly.

Hope, it helps :)