Showing number in 2 decimal places in GridView

asp.net gridview asp.net-3.5
gofor.net picture gofor.net · Oct 13, 2010 · Viewed 99.3k times · Source

I have one GridView in a .aspx page, and am showing dynamic data in this grid, setting AutoGenerateColumns="True".

Depending upon which of the options the user selects in a combo box, I am binding different DataTables to the GridView. For example, if the user selects Persons then I am fetching the Persons DataTable, and if the user selects Products then I am fetching Products DataTable.

How can I show a float or double number in 2 decimal places in GridView?

Answer

moribvndvs picture moribvndvs · Oct 15, 2010

The bound column should have a DataFormatString column. You could do something like:

DataFormatString="{0:0.00}" Numeric Custom Format Strings

UPDATE In the case of AutoGenerateColumns="true"... I'd have to know more specifics about what you're binding, but here are some avenues to explore:

  1. I'm not sure if GridView will respect the DataFormatAttribute in Data Annotations. If you are binding an object, and GridView respects that attribute, that might be one route to go.
  2. Wire the RowDataBound event and inspect each column for potential decimal values, and format that way.

Related questions

How to change the Header Text of Gridview after Databound?

I have a gridview I bound a DataTable with that Gridview Its dynamic so no hardcode Text in desin. I tried to change it after Databound and in PreRender of gridview but no Success. Actually there are Underscores('_') …

Read More
GridView's NewValues and OldValues empty in the OnRowUpdating event

I have the GridView below. I am binding to a custom datasource in the code behind. It gets into the "OnRowUpdating" event just fine, but there are no NewValues or OldValues. Any suggestions as to how I can get these …

Read More
Getting value from a cell from a gridview on RowDataBound event

string percentage = e.Row.Cells[7].Text; I am trying to do some dynamic stuff with my GridView, so I have wired up some code to the RowDataBound event. I am trying to get the value from a particular cell, which …

Read More