how to run remote system C# + sql server application on one machine

Question

1.00/5 (3 votes)

See more:

friends i developed a hospital management system using c# windows form and sql server and i am accessing the database remotely from another computer now i need to run brother sql server database and C# application in one computer how i can do it
plz

thanks in advanced

Posted 4-Mar-15 5:54am

Muhammad Qasim Ludin

Add a Solution

Comments

Richard MacCutchan 4-Mar-15 12:06pm

Exactly the same way you are doing it now, there is no difference.

Muhammad Qasim Ludin 4-Mar-15 12:27pm

no when i disconnect from database server computer its not running and my plan to show this system in just one computer to go to customer place

Muhammad Qasim Ludin 4-Mar-15 13:34pm

give me clear direction ! plz

Sergey Alexandrovich Kryukov 4-Mar-15 14:08pm

What's the problem with that? Directions to what? There are too many ways to make the system remote. And it's no longer important if it's one machine or two (three with front-end client), once the tier next to the front end is made remote.
—SA

Muhammad Qasim Ludin 4-Mar-15 14:46pm

brother my system is distributed the sql server database file is in another pc and my C# file is in my pc now when i am storing data from C# file its saving in another computer when i disconnect the data is not saving how i able to run with server mean without sql srever computer

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2015-03-04T08:18:00

Please see my comment to the question. Therefore, no "clear directions", sorry. You need to build some architecture, and this is should be done only when the goals of your project are more clear, as well as the number of most critical requirements. So, I can only give you the direction for some starting steps.

Learn about system architecture and get some experience in creating of the architecture. I understand, this advice is easier to give than to follow, but what can I do? Perhaps you will have to start with the project you mentioned; I'm not sure.
Learn about tiers and multi-tier architectures: http://en.wikipedia.org/wiki/Multitier_architecture[^].
With .NET and C#, one of the most natural approaches would be using WCF, so this is one thing you need to learn to some essential degree of understanding even if you finally decide to not use it. You simply cannot afford not knowing it. Please see:
http://en.wikipedia.org/wiki/Windows_Communication_Foundation[^],
https://msdn.microsoft.com/en-us/vstudio/aa496123[^],
https://msdn.microsoft.com/en-us/library/dd456779.aspx[^].
Even if you know and properly consider using WCF, you need to take into account that remote operation can be achieved in different levels, from raw sockets to "classical" remoting to WFC. You need to understand how networking works. Please see my overview of these approaches in my past solutions:
how i can send byte[] to other pc[^],
Communication b/w two Windows applications on LAN.[^].

Note that the items I listed are not 1, 2, 3… they are not ordered, are not steps. You decide how and when to approach what. I'm just trying to give your the idea what preliminary steps could be.

Good luck,

—SA