Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server database DB
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 10:11am
Edited 25-Jan-13 10:22am
Rate this: bad
Please Sign up or sign in to vote.

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. [^].
hamaranewton at 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.
Sergey Alexandrovich Kryukov at 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.
hamaranewton at 29-Jan-13 5:48am
Convert numbers to words in English and Asian format
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 at 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? :-)
Rate this: bad
Please Sign up or sign in to vote.

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:[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 515
1 OriginalGriff 450
2 CHill60 305
3 Abhinav S 300
4 Sergey Alexandrovich Kryukov 294
0 Sergey Alexandrovich Kryukov 9,897
1 OriginalGriff 9,395
2 Peter Leow 5,162
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 3,036

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 25 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100