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)); } } } //}