Set currency for dynamic gridview cells in asp.net c#

vignesh t

Hi,

I have a dynamic gridview and formatting needs to be applied for certain columns.

Code:

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 lstCurrency = new List() { "Price", "Amount" };

bool checkAmount = lstCurrency.Exists(o => strHeader.Equals(o));

if (checkAmount)

e.Row.Cells[i].Text = String.Format("{0:C2}", e.Row.Cells[i].Text);

If gridview column header text contains Price or Amount then currency formatting needs to be applied and the above code doesn't work.

Please correct me if I'm doing something wrong.

4 Replies

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

Ajeesh8y ago
Accepted answer
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("Price");
                  lstCurrency.Add("Amount");
                  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
Suraj Kumar8y ago
To know more about culture seeting please visit the following link

http://www.c-sharpcorner.com/UploadFile/0f68f2/converting-a-number-in-currency-format-for-different-culture/
0
Suraj Kumar8y ago
Hello Vignesh,
Any reason why you are setting format from code behind? You can simply format currency from source code as below. First set the culture for India "en-IN" in page section as below

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="frmCurrencyFormat.aspx.cs" Culture="en-IN"
Inherits="CurrencyFormat.frmCurrencyFormat" %>

After that you can use dataformatstring property of gridview aspboundfield column as below

0
Piyush Pansuriya8y ago
Hi Vignesh,

Please try this code :
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;
         if (strHeader.ToString() == "Price" || strHeader.ToString() == "Amount")
         {
            e.Row.Cells[i].Text = String.Format("{0:C2}", e.Row.Cells[i].Text);
         }
      }
   }
}
0