how can I use my inventory system in C# by a multi computer through Local network

Question

1.00/5 (2 votes)

See more:

I've programmed an inventory system in C# using sql server database, how can I use from more than a computer in the same time through a local network?

Posted 16-Oct-15 11:40am

Ma3d Sa3eed

Add a Solution

Comments

ChrisCreateBoss 16-Oct-15 20:30pm

Maybe using System.Net.Sockets? With a TcpServer/Client? There are so many ways to do it. What have you tried?

1 solution

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)

VR Karthikeyan · Accepted Answer · 2015-10-16T19:04:00

Solution 1

Hi, Setup your inventory database in a separate system(server), and configure the database to allow remote connections. Now you have to modify your connection string, connection string needs to be pointed the database in the server.

C#

Data Source=127.2.3.4\SQLEXPRESS,1433;Network Library=DBMSSOCN;Initial Catalog=database_name_here;User ID=user_id_here;Password=password_here

Data Source=127.2.3.4\SQLEXPRESS,1433;, in this line,
127.2.3.4 - denotes the server IP address.
SQLEXPRESS - denotes the database server instance.
1433 - denotes the server port number.
After setup of the database server, you can use your application in any PC inside the LAN, and it will connects the database in the server as per the connection string.

Posted 16-Oct-15 19:04pm

VR Karthikeyan

Comments

Ma3d Sa3eed 17-Oct-15 3:21am

Hello, brother.
thanks for your help, but I have a simple question, please.
where should I put my database file? in which path in server?
I don't know anything in networks?

VR Karthikeyan 17-Oct-15 4:22am

Which database you are using?

Ma3d Sa3eed 17-Oct-15 14:20pm

sql sever database

VR Karthikeyan 18-Oct-15 11:15am

install SQL Server in server and put your files in the following folder of SQL Server - C:\Program Files\Microsoft SQL Server\MSSQL.90\MSSQL\Data\

VR Karthikeyan 18-Oct-15 11:27am

After adding your files to the SQL Server database, you need to attach the .mdb files to your SQL Server Instance running on your Server. For that, follow the instructions on the following link - Attach .mdb files to SQL Server Instance. And you need to enable remote access to the SQL Server, for that refer this link - SQL Server Configuration to Allow Remote Access. After this setup, you can able to connect your database from your application which installed on different PC in same LAN by using the connection string specified in the solution.

Ma3d Sa3eed 19-Oct-15 16:09pm

Thank you brother for your help, I will start doing these steps.
Can you please send me your email to get more aid as per need? :)

VR Karthikeyan 20-Oct-15 1:10am

you're welcome, karthikeyangvp@gmail.com

Ma3d Sa3eed 20-Oct-15 3:27am

I am grateful for your help, brother.
Thank you very much :)