Click here to Skip to main content
Rate this: bad
good
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 9:11am
Edited 25-Jan-13 9:22am
v2
Rate this: bad
good
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. [^].
 
—SA
  Permalink  
Comments
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.
thanks
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.
—SA
hamaranewton at 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 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? :-)
—SA
Rate this: bad
good
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:
http://access.mvps.org/access/modules/mdl0001.htm[^]
  Permalink  

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



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