Currency formating in asp.net

See more:

ASP.NET

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.