How to Convert in this Screnario
HiHow to create function Decimal to words. - (Sql Server )
I need following output this
--823456.21
--Eight Lakh Twenty Three Thousand Four Hundread Fifty Six and Twenty one Paise Only
You must Sign In to post a response.
Category: ASP.NET
How to create function Decimal to words. - (Sql Server )
I need following output this
#768531
Hi,
We have do it by own coding. Initially we need to check how many integers are there given, based on that we need to pass the values.
Thanks,
Mani
We have do it by own coding. Initially we need to check how many integers are there given, based on that we need to pass the values.
public string ConvertDecimaltoWords(long number)
{
if (number == 0) return "ZERO";
if (number < 0) return "minus " + ConvertDecimaltoWords(Math.Abs(number));
string words = "";
if ((number / 100000000) > 0)
{
words += ConvertDecimaltoWords(number / 10000000) + " CRORES";
number %= 10000000;
}
if ((number / 100000) > 0)
{
words += ConvertDecimaltoWords(number / 100000) + " LAKHS";
number %= 1000000;
}
if ((number / 1000) > 0)
{
words += ConvertDecimaltoWords(number / 1000) + " THOUSANDS";
number %= 1000;
}
if ((number / 100) > 0)
{
words += ConvertDecimaltoWords(number / 100) + " HUNDREDS";
number %= 100;
}
if ((number / 10) > 0)
{
words += ConvertDecimaltoWords(number / 10) + " RUPEES ";
number %= 10;
}
if (number > 0)
{
if (words != "") words += "AND ";
var unitsMap = new[]
{
"ZERO", "ONE", "TWO", "THREE", "FOUR", "FIVE", "SIX", "SEVEN", "EIGHT", "NINE", "TEN", "ELEVEN", "TWELVE", "THIRTEEN", "FOURTEEN", "FIFTEEN", "SIXTEEN", "SEVENTEEN", "EIGHTEEN", "NINETEEN"
};
var tensMap = new[]
{
"ZERO", "TEN", "TWENTY", "THIRTY", "FORTY", "FIFTY", "SIXTY", "SEVENTY", "EIGHTY", "NINETY"
};
if (number < 20) words += unitsMap[number];
else
{
words += tensMap[number / 10];
if ((number % 10) > 0) words += " " + unitsMap[number % 10];
}
}
return words;
}
Thanks,
Mani
Return to Return to Discussion Forum