title: How to display enum values in datagridview column
body: <p>I have this Database, not of my design but I have to work with it, that contains a table like so :  </p>
  
  <pre>
   id  |   Name     |  status  | ...
  -----+------------+----------+------
   1   |  Product1  |  2       | ...
   2   |  Product2  |  2       | ...
   3   |  Product3  |  3       | ...
   ... |  ...       |  ...     | ...
  </pre>
  
  <p>The status property refers to an enum where  </p>
  
  <pre>
  0 = Invalid
  1 = Dev
  2 = Activ
  3 = Old
  </pre>
  
  <p>When I display this in a read-only datagridview, I would like the user to see the name of the enum (Dev, Activ, ...) or a description instead of the numeric value. The datagridview is bound to a datatable that comes from a DAL, again not of my design, so I can't really change the datatable. The only way I found how to do that is by listening to the datagridview.CellFormating event where I put this code:  </p>
  
  <pre><code>private void dataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  {
      if (e.ColumnIndex == 3) // column of the enum
      {
          try
          {
              e.Value = getEnumStringValue(e.Value);
          }
          catch (Exception ex)
          {
              e.Value = ex.Message;
          }
      }
  }
  </code></pre>
  
  <p>This works fine, except that if I have around 1k (not that much) or more items, it takes forever...
  Is there a better way to do this ?</p>
  
  <p>---Edit---<br>
  This works fine as it is, my problem is that if there are more than 1000 rows in the datatable, it takes for ever. The problem is that the CellFormating event fires for every column, even the ones that don't need it. Let say I display 15 columns and there is 1000 rows, then that event fires 15 000 time...  </p>
  
  <p>Is there a better way than using the CellFormating Event ? Or is there a way to add the CellFormating Event to only one Column ? Or what ?</p>