Click here to Skip to main content
15,032,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In sql server 2005 i am create a table. like:-
Name    Amount
Prince      10
Rakesh      20

in above table Name is varchar(50) and Amount is money data type.

In above table i am display in datalist. but is display like
Name    Amount
Prince   10.0000
Rakesh   20.0000

but i want to display like:-
Name    Amount
Prince      Rs 10.00
Rakesh      Rs 20.00

I am also try for formating like {0:c} but it is display $ symbol but i need to display Rs in place $. So please help me, how to solve above scenario.
Updated 5-Apr-11 22:23pm

You can think about concatenation and split values.

select name, ('Rs ' + cast( amount as varchar(50))) as aa from currency
You should be able to change the currency symbol in regional settings.
Rakesh From Patna 6-Apr-11 4:49am
my database is in server. so i am not change the regional settings
CodingLover 6-Apr-11 5:40am
you don't have access to the server? Then you have to do some manipulation in BL, which is quite bad to do.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900