Currency into word in crystal reports or asp.net.

Question

Hi Experts I have one problem in Crystal report or asp.net. when my total is 2455 then it display also in character like this Two thousand four hundred fifty five. Thanks In advance CurrencyJitendra Patel

Vulpes · Answer

Further to my response to your article comment here's my version for the Indian number system: using System; class Program { static void Main() { string input; int number; bool isValid; bool useAnd = false; Console.WriteLine(
Enter '0' to quit the program at any time
); while (true) { Console.Write(
Use 'and' as separator y/n : ); input = Console.ReadLine(); if (!(input.ToLower() == y || input.ToLower() == n)) Console.WriteLine(
 Must be 'y' or 'n' please try again
); else { if (input.ToLower() == y) useAnd = true; Console.WriteLine(
); break; } } do { Console.Write(Enter integer : ); input = Console.ReadLine(); isValid = int.TryParse(input out number); if (!isValid) Console.WriteLine(
 Not an integer please try again
); else Console.WriteLine(
 {0}
 NumberToText(number useAnd)); } while (!(isValid && number == 0)); Console.WriteLine(
Program ended); } public static string NumberToText(int number bool useAnd) { if (number == 0) return Zero; string and = useAnd ? and  : ; // deals with using 'and' separator if (number == -2147483648) return Minus Two Hundred  + and + Fourteen Crore Seventy Four Lakh Eighty Three Thousand Six Hundred  + and +Forty Eight; int[] num = new int[4]; int first = 0; int u h t; System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (number { sb.Append(Minus ); number = -number; } string[] words0 = { One  Two  Three  Four  Five  Six  Seven  Eight  Nine }; string[] words1 = {Ten  Eleven  Twelve  Thirteen  Fourteen  Fifteen  Sixteen  Seventeen  Eighteen  Nineteen }; string[] words2 = {Twenty  Thirty  Forty  Fifty  Sixty  Seventy Eighty  Ninety }; string[] words3 = { Thousand  Lakh  Crore  }; num[0] = number % 1000; // units num[1] = number / 1000; num[2] = number / 100000; num[1] = num[1] - 100 * num[2]; // thousands num[3] = number / 10000000; // crores num[2] = num[2] - 100 * num[3]; // lakhs for (int i = 3; i > 0; i--) { if (num[i] != 0) { first = i; break; } } for (int i = first; i >= 0; i--) { if (num[i] == 0) continue; u = num[i] % 10; // ones t = num[i] / 10; h = num[i] / 100; // hundreds t = t - 10 * h; // tens if (h > 0) sb.Append(words0[h] + Hundred ); if (u > 0 || t > 0) { if (h > 0 || i if (t == 0) sb.Append(words0[u]); else if (t == 1) sb.Append(words1[u]); else sb.Append(words2[t - 2] + words0[u]); } if (i != 0) sb.Append(words3[i - 1]); } return sb.ToString().TrimEnd(); } } If you enter 'no' to using 'and' and then enter : 125480 it should return: One Lakh Twenty Five Thousand Four Hundred Eighty

Vulpes · Answer

Thanks Suthish :) Might do a quick article now that point has been confirmed. It does seem a strange term but I found it mentioned in this Wikipedia article ( http://en.wikipedia.org/wiki/Indian_numbering_system ) in case you're wondering where I've got it from.

Suthish Nair · Answer

yes its 1 billion = 100 crores. but Arab - relating to Arabia and the people of Arabia.

Vulpes · Answer

Jitendra and Suthish In India today for one billion would you say it was commoner to use 100 crore or one arab? When I wrote this program I was told that the term 'arab' was seldom used but I wondered whether you agreed with that?

Jitendra Patel · Answer

Hello Dear Thanks a lots. I shell never forget you kindness. Thank u very much for share you knowledge. Keep it up

Jitendra Patel · Answer

Dear All I got the Solution but it is work only in Sqlserver 2008 and 2005 Not work in 2000................. If any idea to work in 2000 please help me... My database in sqlserver 2000.

Jitendra Patel · Answer

Hello Enjoy this function it is work perfectly USE [Test] GO /****** Object: UserDefinedFunction [dbo].[fnNumberToWords] Script Date: 05/02/2011 15:47:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[fnNumberToWords](@Number as BIGINT) RETURNS VARCHAR(1024) AS BEGIN DECLARE @Below20 TABLE (ID int identity(01) Word varchar(32)) DECLARE @Below100 TABLE (ID int identity(21) Word varchar(32)) INSERT @Below20 (Word) VALUES ( 'Zero') ('One')( 'Two' ) ( 'Three') ( 'Four' ) ( 'Five' ) ( 'Six' ) ( 'Seven' ) ( 'Eight') ( 'Nine') ( 'Ten') ( 'Eleven' ) ( 'Twelve' ) ( 'Thirteen' ) ( 'Fourteen') ( 'Fifteen' ) ('Sixteen' ) ( 'Seventeen') ('Eighteen' ) ( 'Nineteen' ) INSERT @Below100 VALUES ('Twenty') ('Thirty')('Forty') ('Fifty') ('Sixty') ('Seventy') ('Eighty') ('Ninety') DECLARE @English varchar(1024) = ( SELECT Case WHEN @Number = 0 THEN '' WHEN @Number BETWEEN 1 AND 19 THEN (SELECT Word FROM @Below20 WHERE ID=@Number) WHEN @Number BETWEEN 20 AND 99 THEN (SELECT Word FROM @Below100 WHERE ID=@Number/10)+ '-' + dbo.fnNumberToWords( @Number % 10) WHEN @Number BETWEEN 100 AND 999 THEN (dbo.fnNumberToWords( @Number / 100))+' Hundred '+ dbo.fnNumberToWords( @Number % 100) WHEN @Number BETWEEN 1000 AND 99999 THEN (dbo.fnNumberToWords( @Number / 1000))+' Thousand '+ dbo.fnNumberToWords( @Number % 1000) WHEN @Number BETWEEN 100000 AND 999999 THEN (dbo.fnNumberToWords( @Number / 100000))+' Lakh '+ dbo.fnNumberToWords( @Number % 100000) WHEN @Number BETWEEN 1000000 AND 9999999 THEN (dbo.fnNumberToWords( @Number / 1000000))+' Cr. '+ dbo.fnNumberToWords( @Number % 1000000) ELSE ' INVALID INPUT' END ) SELECT @English = RTRIM(@English) SELECT @English = RTRIM(LEFT(@Englishlen(@English)-1)) WHERE RIGHT(@English1)='-' RETURN (@English) END

Vulpes · Answer

I'm not sure whether it will help in your particular scenario but check out my article on converting numbers to words ( http://www.c-sharpcorner.com/UploadFile/b942f9/6362/?ArticleID=0910264a-898f-49be-84b5-38b5b5f83a15 ). I also have a version for the Indian number system (lakhs crores) which I can dig out if you need it.

Jitendra Patel · Answer

Hello Suthish Above my post(function) is not working perfectly. So please give me a solution. Thanks In Advance Jitendra Patel

Suthish Nair · Answer

Ok did you followed the links i posted for permanent solutions?

Jitendra Patel · Answer

Hello All I have solved my problem but not in crystal report or asp.net. I have create function in SQL Server. please refer below link.... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86067 I have temparory solved this problem not perment. Thanks Jitendra

Suthish Nair · Answer

There is no direct way. refer links.. 1  2