Decimal formatting within Gridview control

Question

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

Rajanikant Hawaldar · Answer

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 { 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)); } } } }

Decimal formatting within Gridview control

Answers (1)