add comma to numbers in gridvew

Question

0.00/5 (No votes)

See more:

hi developers,

how to add comma to numbers in gridview.please help me its ~~urgent~~.
presently i conveting to decimal using math.round method and getting like this.(50000)

but i need like this-50,000

sorry for grammer mistakes

Regards
Aravind

Posted 6-Apr-12 23:24pm

Aravind Garre

Updated 7-Apr-12 2:47am

Not Active

v2

Add a Solution

Comments

[no name] 7-Apr-12 8:48am

Don't ask for urgent help, it is rude. It may be urgent to you but no one else here. This is a volunteer site and people will answer on their time, not yours.

Nilesh Patil Kolhapur 7-Apr-12 8:54am

u can manually change it before binding to grid view

3 solutions

Solution 1

Formatting can be allied with your databinding expression.

Try reading the documentation
http://msdn.microsoft.com/en-us/library/2d76z3ck.aspx[^]

Posted 7-Apr-12 2:50am

Not Active

Solution 3

Wow! You have accepted probably the worst solution. No, here is the good one:
Displaying number in thousands format[^].

—SA

Posted 11-Apr-12 15:53pm

Sergey Alexandrovich Kryukov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravind Garre · Accepted Answer · 2012-04-10T02:46:00

C#

#region FormatNumber
     public string FormatNumber(string strNumber)
     {
         string test;
         try
         {
             if (strNumber.Length == 1)
             {
                 return strNumber;
             }
             else if (string.Compare(strNumber, "0", false) == 0)
             {
                 return strNumber;
             }
             else if (strNumber.Length == 2)
             {
                 return strNumber;
             }
             else if (strNumber.Length == 3)
             {
                 return strNumber;
             }
             else if (strNumber.Length == 4)
             {
                 return strNumber.Substring(0,1)+","+strNumber.Substring(1);
             }
             else if (strNumber.Length == 5)
             {
                 return strNumber.Substring(0, 2) + "," + strNumber.Substring(2);
             }
             else if (strNumber.Length == 6)
             {
                test= strNumber.Substring(0, 3) + "," + strNumber.Substring(3);
                return test;
             }
             else if (strNumber.Length == 7)
             {
                 return strNumber.Substring(0, 1) + "," + strNumber.Substring(1, 3) + "," + strNumber.Substring(4);
             }
             else if (strNumber.Length == 8)
             {
                 return strNumber.Substring(0, 2) + "," + strNumber.Substring(2, 3) + "," + strNumber.Substring(5);
             }
             else if (strNumber.Length == 9)
             {
                 return strNumber.Substring(0, 3) + "," + strNumber.Substring(3, 3) + "," + strNumber.Substring(6);
             }
             else if (strNumber.Length == 10)
             {
                 return strNumber.Substring(0, 1) + "," + strNumber.Substring(2, 3) + "," + strNumber.Substring(4, 3) + "," + strNumber.Substring(7);
             }
             else if (strNumber.Length == 11)
             {
                 return strNumber.Substring(0, 2) + "," + strNumber.Substring(2, 3) + "," + strNumber.Substring(5, 3) + "," + strNumber.Substring(8);
             }
             else if (strNumber.Length == 12)
             {
                 return strNumber.Substring(0, 3) + "," + strNumber.Substring(3, 3) + "," + strNumber.Substring(6, 3) + "," + strNumber.Substring(9);
             }
             else
             {
                 return "false";
             }
         }
         catch (NullReferenceException nullex)
         {
             objError.LoggerError(nullex);
             lblErrorMessage.Text = nullex.Message;
             return "FALSE";
         }
         catch (SqlException sqlex)
         {

             objError.LoggerError(sqlex);
             lblErrorMessage.Text = sqlex.Message;
             return "FALSE";
         }
         catch (Exception ex)
         {
             objError.LoggerError(ex);
             lblErrorMessage.Text = ex.Message;
             return "FALSE";
         }

     }


     #endregion

this is the solution i for comma b/w numbers......