How to connect multiple computers to the database in Windows Form C#

Question

I have a Windows Forms application that I want to install the database on one computer and install the Windows Forms application on several other computers that are all connected to the same network so that any user who adds information to the database can be viewed by other users.

Answer 1

Hi @marzban hadian , Welcome to Microsoft Q&A,

You don't need to download visual studio in a production environment. You only need to download the corresponding operating environment, which can usually be selected in the installation package.

For the database, a database driver for the applicable database type needs to be installed in the production environment. For example, if you are using a SQL Server database, you need to install the SQL Server database driver.

This is possible if you want to use the same database. It is more recommended that you place the database on a network server. You can have a good connection after using it in the application.

If you plan to use the database on your local computer, you need to do the corresponding network connection homework yourself, which may be a bit complicated for novices.

Best Regards,

Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

On one on the computers you will need to install the database server. You don’t specify which database engine you are using. You will then probably need a discovery service, or a configuration ui for the users to specify the name of the computer picked to host the database. Database servers typically have minimum hardware requires, so be sure the users have one. Also how are you backing up the database?

You don’t specify what .net framework you are using, but this must be installed on the users machine. You probably need an installer app.