format of data grid number to nimaric

Question

0.00/5 (No votes)

See more:

I am trying to format a datagrid column to number format with comma. this is not working in my latest application. I am using the DataFormatString property but it returns the number without comma. I even tried the format "{0:N}", but same result.
here is my code

C#

BoundColumn BoundColumn=new BoundColumn();
BoundColumn DataField=Store Quantity; 
BoundColumn.HeaderText=Quantity;
BoundColumn.ItemStyle-HorizontalAlign=Right;
BoundColumn.DataFormatString="{0:N}";

The source for the datagrid is a DataTable whcih is created dynamically.

Posted 20-Jan-12 21:17pm

Aravind Garre

Updated 20-Jan-12 21:35pm

koolprasad2003

v2

Add a Solution

2 solutions

Solution 2

hello Aravind
in your original code, you have mentioned "Store Quantity", what column is that related to?

Posted 23-Jan-12 13:29pm

Sriram Chitturi

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)

Sriram Chitturi · Accepted Answer · 2012-01-22T02:17:00

Solution 1

Make sure that in the DataTable, for the column Store Quantity, the data type is one of the numeric types (int, float etc). If it is string, then the numeric format is ignored.

Posted 22-Jan-12 2:17am

Sriram Chitturi

Comments

Aravind Garre 22-Jan-12 23:37pm

hi sriram chitturi,

Thanks For Helping....

Aravind Garre 23-Jan-12 0:02am

hi Sriram,
i am given like this but still not coming numaric format .and i try convert to int
please find below code.
if (!(ds1.Tables[j].Rows[i]["TotalValue"] ==DBNull.Value))
{
dr["TotalValueOfOperatingSoftwares"] = ds1.Tables[j].Rows[i]["TotalValue"];

}
table.Rows.Add(dr);
GV1.DataSource = table;
GV1.DataBind();