How to format string of column of gridview with thousand seperator in ASP.NET C#

Hi,

In addition to phil.o's comment.

Have a look at the manual for Decimal.ToString Method (String) (System)[^]

You can then use it like:

decimal result;
if (e.Row.RowType == DataControlRowType.DataRow)
{
    if (decimal.TryParse(e.Row.Cells[4].Text, out result)) {
         e.Row.Cells[4].Text = result.ToString("0,0");
    }
}

... hope it helps.

// Right Align Decimal Fields in GridView Row
decimal result;
for (int i = 1; i < e.Row.Cells.Count; i++)
{
if (decimal.TryParse(e.Row.Cells[i].Text, out result))
{
e.Row.Cells[i].HorizontalAlign = HorizontalAlign.Right;
}
}