Is it possible to set the DataFormatString property of a column or cell in an ASP.NET DataGridView at runtime?
A:
Not that I know of, you might want to try peforming the column formatting on RowDataBound event though might have some performance degrade. Will be glad if someone can provide a simpler method.
o.k.w
2009-08-13 15:57:14
A:
This should work.
BoundField priceField = grid.Columns[0] as BoundField;
priceField.DataFormatString = "{0:c}";
priceField.HtmlEncode = false;
grid.DataSource = list;
grid.DataBind();
Found via http://geekswithblogs.net/michelotti/archive/2006/03/30/73896.aspx
thinkzig
2009-08-13 19:55:59
Will it work for AutoGenerated columns? Doubt so huh?
o.k.w
2009-08-13 23:26:52
A:
There doesn't seem to be a way to set the DataFormatString property. I have ended up binding the datasource to the table and then going through all the cells and formatting them manually:
DataGridView.AutoGenerateColumns = true;
DataGridView.DataSource = dbconnection.getDataReader();
DataGridView.DataBind();
int result;
for (int i = 0; i < DataGridView.Rows.Count; i++)
{
foreach (TableCell c in DataGridView.Rows[i].Cells)
{
if (int.TryParse(c.Text, out result))
{
c.Text = String.Format("{0:n0}", result);
}
}
}
This method works perfectly for me. Not sure how it would scale up with a large dataset although my guess is it would be fine.
macleojw
2009-08-24 21:29:18