Decimal formatting within Gridview control

I have a gridview control with a item template column as

"TOTAL FEE">
"LTFEE" runat="server" Text="">

on code behind I want to format the column with indian currency with 2 decimal places. I tried this code in RowDataBound event, but it does not format the column.

(e.Row.FindControl("LTFEE") as Label).Text = string.Format("{0:n2}", DataBinder.Eval(e.Row.DataItem, "TFEE").ToString());

What I did wrong, please help me in this regard Thank u

Hi Anand, try this.

e.Row.Cells[i].Text will return a value of type string. Hence you need to convert the value to decimal before using String.Format

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
for (int i = 0; i < GridView1.HeaderRow.Cells.Count; i++)
{
string strHeader = GridView1.HeaderRow.Cells[i].Text;
List<string> lstCurrency = new List<string>();
lstCurrency.Add("TOTAL FEE"); // Price
//lstCurrency.Add("Amount"); // you can add multiple columns here to format
bool checkAmount = lstCurrency.Exists(o => strHeader.Equals(o));
if (checkAmount)
{
//Convert the value to Decimal before applying format
e.Row.Cells[i].Text = String.Format("{0:C2}", Convert.ToDecimal(e.Row.Cells[i].Text));
}
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Hi Anand, try this.
e.Row.Cells[i].Text will return a value of type string. Hence you need to convert the value to decimal before using String.Format
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
      {
          if (e.Row.RowType == DataControlRowType.DataRow)
          {
              for (int i = 0; i < GridView1.HeaderRow.Cells.Count; i++)
              {
                  string strHeader = GridView1.HeaderRow.Cells[i].Text;
                  List<string> lstCurrency = new List<string>();
                  lstCurrency.Add("TOTAL FEE"); // Price
//lstCurrency.Add("Amount"); // you can add multiple columns here to format
                  bool checkAmount = lstCurrency.Exists(o => strHeader.Equals(o));
                  if (checkAmount)
                  {
                      //Convert the value to Decimal before applying format
                      e.Row.Cells[i].Text = String.Format("{0:C2}", Convert.ToDecimal(e.Row.Cells[i].Text));
                  }
            }
      }
}
0