How do I make the centralized database sql server 2008

Question

1.50/5 (2 votes)

See more:

I have already make the application in C# (2010) and SQL SERVER 2008 (SQL Server Management Studio R2). My Application work well but now i want to convert my application to server client environment.

I want to keep the database on one computer and multiple computers access this database through my application.

Please Help me which changes i made to solve this problem.

And my another problem is I want to convert amount into words.
Like this
1 = ONE Only
10 = Ten Only
320 = Three Hundred Only
4100.25 = Four Thousand One Hundred and Twenty Five Pisa

Posted 25-Jan-13 9:11am

hamaranewton

Updated 24-Jan-18 22:08pm

v2

Add a Solution

2 solutions

Solution 2

1. Install SQL Server on the database server computer. Change the ConnectionString Server parameter on the other computers to name the database server computer.

2. Here is another solution that you can use to develop your own currency formatting code:
http://access.mvps.org/access/modules/mdl0001.htm[^]

Posted 25-Jan-13 9:25am

Mike Meinz

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 · Accepted Answer · 2013-01-25T09:22:00

Solution 1

First question: not clear what help do you want. You need to ask a question to get help.

Second question: please see these CodeProject articles:
Convert numbers to words in English and Asian format[^],
Converting numbers to the word equivalent. [^].

—SA

Posted 25-Jan-13 9:22am

Sergey Alexandrovich Kryukov

Comments

hamaranewton 29-Jan-13 3:26am

actually i am doing a project in which,i'll keep the database in one system and now i want to access this database from other systems which are connected across the network and also from the same system in which the database is installed.
i dont know which connection to use.
thanks

Sergey Alexandrovich Kryukov 29-Jan-13 3:35am

OK, but this is should be a separate question. I answered the main and non-trivial part. Will you accept this answer formally (green button)? — thanks.
—SA

hamaranewton 29-Jan-13 5:48am

Convert numbers to words in English and Asian format
http://www.codeproject.com/Articles/305408/Convert-numbers-to-words-in-English-and-Asian-form

This work for me but it not convert decimal number like this.
143.34 = One hundred Forty Three and thirty four paisa

Sergey Alexandrovich Kryukov 29-Jan-13 6:00am

Of course, I meant the you might adjust code a bit. And this is because this "only" is not a regular way to phrase English numerals, looks rather like some jargon. Are you sure you need it? Anyway, guess who should do it? :-)
—SA