Convert numaric to cherecter

Question

Hello dear

i am in problem to convert amount to spelling such as in databse 100 output is (one hundred)

create table transection
(
ID int primary key,
name varchar(50),
amount money)

Enter Amount

ID

Name

Amount

ID

10
Rowshan ali
1847
One thousend eight hundred forty seven

If any one can help me best regurd.

R ACHUTHA · Answer

hi, refer http://howtouseasp.net/convert-numbers-into-words-asp-net-c/

Satyapriya Nayak · Answer

Untitled Page onclick="btn_search_Click" /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Search_insert_records { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void btn_add_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = "Insert into transactions values(@ID,@name,@amount )"; com.Parameters.Clear(); com.Parameters.AddWithValue("@ID", txt_id.Text); com.Parameters.AddWithValue("@name", txt_name.Text); com.Parameters.AddWithValue("@amount ", txt_amount.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Successfully Enter!!!"; clear(); } private void clear() { txt_id.Text = ""; txt_name.Text = ""; txt_amount.Text = ""; } protected void btn_search_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select * from transactions where ID = '" + txt_search.Text + "'"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { lbl_id.Text = reader["ID"].ToString(); lbl_name.Text = reader["name"].ToString(); lbl_amount.Text = reader["amount"].ToString(); } reader.Close(); con.Close(); lbl_amount_words.Text = NumberToText.Convert(Convert.ToDecimal(lbl_amount.Text)); } } } NumToText.cs using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.IO; using System.Collections.Generic; using System.Text; namespace Search_insert_records { //public class NumToText //{ static class NumberToText { private static string[] _ones = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" }; private static string[] _teens = { "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen" }; private static string[] _tens = { "", "ten", "twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety" }; // US Nnumbering: private static string[] _thousands = { "", "thousand", "million", "billion", "trillion", "quadrillion" }; /// /// Converts a numeric value to words suitable for the portion of /// a check that writes out the amount. /// /// Value to be converted /// public static string Convert(decimal value) { string digits, temp; bool showThousands = false; bool allZeros = true; // Use StringBuilder to build result StringBuilder builder = new StringBuilder(); // Convert integer portion of value to string digits = ((long)value).ToString(); // Traverse characters in reverse order for (int i = digits.Length - 1; i >= 0; i--) { int ndigit = (int)(digits[i] - '0'); int column = (digits.Length - (i + 1)); // Determine if ones, tens, or hundreds column switch (column % 3) { case 0: // Ones position showThousands = true; if (i == 0) { // First digit in number (last in loop) temp = String.Format("{0} ", _ones[ndigit]); } else if (digits[i - 1] == '1') { // This digit is part of "teen" value temp = String.Format("{0} ", _teens[ndigit]); // Skip tens position i--; } else if (ndigit != 0) { // Any non-zero digit temp = String.Format("{0} ", _ones[ndigit]); } else { // This digit is zero. If digit in tens and hundreds // column are also zero, don't show "thousands" temp = String.Empty; // Test for non-zero digit in this grouping if (digits[i - 1] != '0' || (i > 1 && digits[i - 2] != '0')) showThousands = true; else showThousands = false; } // Show "thousands" if non-zero in grouping if (showThousands) { if (column > 0) { temp = String.Format("{0}{1}{2}", temp, _thousands[column / 3], allZeros ? " " : ", "); } // Indicate non-zero digit encountered allZeros = false; } builder.Insert(0, temp); break; case 1: // Tens column if (ndigit > 0) { temp = String.Format("{0}{1}", _tens[ndigit], (digits[i + 1] != '0') ? "-" : " "); builder.Insert(0, temp); } break; case 2: // Hundreds column if (ndigit > 0) { temp = String.Format("{0} hundred ", _ones[ndigit]); builder.Insert(0, temp); } break; } } // Append fractional portion/cents builder.AppendFormat("and {0:00}/100", (value - (long)value) * 100); // Capitalize first letter return String.Format("{0}{1}", Char.ToUpper(builder[0]), builder.ToString(1, builder.Length - 1)); } } } //}