Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oguzkaygun
Yak Posting Veteran
53 Posts |
 Posted - 2009-01-17 : 06:52:34
|
| Hellomy gridview1 dislpay money as 5,00 YTL.. YTL is Turkish money.. i am from Turkey.. but YTL belong to past..2008 and past.. now it is TL without Y..how my gridview1 display money as 5,OO TL |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-17 : 07:01:08
|
Change format in your grid view.SQL Server data type MONEY doesn't carry the currency sign.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2009-01-17 : 07:15:37
|
| my format is {c:0}what should i write ? do you know ? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-17 : 07:31:52
|
{c:0} means your application get the currency symbol from the computer where the code is presented, which should be your client machine.Goto Control Panel and Regional Settings and change currency symbol there.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2009-01-17 : 08:06:03
|
| thank you for your reply.. it display TL now..but my webiste run on my computer now..what will happen if server have different currency symbol?it display like 9.999.999,00 TL now.. is there a format for this ? so it runs all server like this :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-17 : 08:25:21
|
quote:
Originally posted by oguzkaygun
thank you for your reply.. it display TL now..but my webiste run on my computer now..what will happen if server have different currency symbol?it display like 9.999.999,00 TL now.. is there a format for this ? so it runs all server like this :)
then you need to use formatting functions at your front end to show data in reqd data |
|
|
|
oguzkaygun
Yak Posting Veteran
53 Posts |
Posted - 2009-01-17 : 09:21:26
|
| i use this now :) {0:#,###.00} TLi think that rent server.. Should i change my money format to {0:#,###.00} TLor server company install turkish SQL and change curreny money format for me? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-17 : 09:29:45
|
If you change it for the grid, it doesn't matter what regional settings the server has for currency.Currency value is just a number.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Money Format