How to convert currency values while select the amount using Sql Server with Visual Studio 2005

Question

How to convert currency values while select the amount using Sql Server with Visual Studio 2005. Please help me: from example values(indian rupees) to values($)

Mamta M · Answer

You will have to write a user-defined method for that which accepts the amount and returns the converted value which can then be used in the form/table depending on where you want to show the converted value. The method will use the relevant formula. For example private double ConvertToDollars(double inputINR) { double dollars = inputINR/52; //supposing that 52 Rs is one dollar return dollars; }