Separate number with comma for thousands asp.net

Question

How do you do separate numbers with commas for every thousand on asp.net gridview (with c# in the back)

I have been trying the following lines (individually) in the backend(nothing works, they just cut off the decimal places)

row["Applied_Amount_Varience_Sum"] = string.Format("{0:#,###0}", Convert.ToDecimal(row["Applied_Amount_Varience_Sum"]));
row["Applied_Amount_Varience_Sum"] = Convert.ToDecimal(row["Applied_Amount_Varience_Sum"]).ToString("#,##0.00"); 
row["Applied_Amount_Varience_Sum"] = String.Format("{0:n}", Convert.ToDecimal(row["Applied_Amount_Varience_Sum"]));
row["Applied_Amount_Varience_Sum"] = Convert.ToDecimal(row["Applied_Amount_Varience_Sum"]).ToString("N0");

row is a reference to the table in the database (I am looping through each object returned and going through the rows)

I have putting this where I bind to the gridview. So basically I right before it binds I change those attributes to have a comma but it doesn't do that

The lines I tried will change this

1092.00

to this

but I am trying to achieve this

1,092

* EDIT *

This is within a template field (because I needed it to be a link with an onclick function

<asp:TemplateField ItemStyle-HorizontalAlign="Center" HeaderText="Applied Amount Variance">
  <ItemTemplate>
    <asp:LinkButton ID="LbPath" runat="server" 
                    Text='<%# Eval("Applied_Amount_Varience_Sum") %>'
                    CommandName="BindExpand" 
                    OnCommand="BindExpand"
                    CommandArgument='<%#Bind("Applied_Amount_Varience_Sum") %>'>
    </asp:LinkButton>
  </ItemTemplate>
</asp:TemplateField>

What is `row`? Is it a row in a DataTable or a row in the GridView? — D Stanley, Jul 22 '15 at 19:14
Do you want a currency? DataFormatString="{0:c}" This will give you a currency format. — wolfeh, Jul 22 '15 at 19:16
row["Applied_Amount_Varience_Sum"] = String.Format("{0:N2}", Convert.ToString(row["Applied_Amount_Varience_Sum"])); — Kevin, Jul 22 '15 at 19:36
row["Applied_Amount_Varience_Sum"] = String.Format("{0:c}", Convert.ToString(row["Applied_Amount_Varience_Sum"])); — Kevin, Jul 22 '15 at 19:36

wolfeh · Accepted Answer · 2015-07-22T19:56:48.413

9

IF you are looking for Currency use

DataFormatString="{0:c}"

otherwise use

DataFormatString="{0:N2}"

Try

    Text='<%# Eval("Applied_Amount_Varience_Sum","{0:c}") %>'

or

    Text='<%# Eval("Applied_Amount_Varience_Sum","{0:N2}") %>'

edited Jul 22 '15 at 19:56

answered Jul 22 '15 at 19:30

wolfeh

666
1
8
23

I am trying these two lines now (in both it doesn't change the line, so 1092.00 will turn to 1092.00) – Kevin Jul 22 '15 at 19:36
row["Applied_Amount_Varience_Sum"] = String.Format("{0:N2}", Convert.ToString(row["Applied_Amount_Varience_Sum"])); – Kevin Jul 22 '15 at 19:37
row["Applied_Amount_Varience_Sum"] = String.Format("{0:c}", Convert.ToString(row["Applied_Amount_Varience_Sum"])); – Kevin Jul 22 '15 at 19:37
Have you tried these in your front end aspx ?? – wolfeh Jul 22 '15 at 19:38
Your edit gives "Format specifier was invalid" on this line – Kevin Jul 22 '15 at 19:59

score 4 · Answer 2 · answered Jul 22 '15 at 19:27

4

private string commaSeparateNumber(string value)
{
    return String.Format("{0:#,##0}", int.Parse(value));
}

works for me.

in yor first line "{0:#,###0}", drop one #

answered Jul 22 '15 at 19:27

Kiryl

95
4

Separate number with comma for thousands asp.net

2 Answers2

Linked