title: C# changing DataGridView cell Type (error?)
body: <p>I have a DataGridView linked to a DataTable.
  The cells in the table are set to decimal.</p>
  
  <p>In the case of no relevant data, I wish to diaply "No Data" text in the "power" column (#2) rather than the value.</p>
  
  <p>For that, I do the following:</p>
  
  <pre><code>foreach (DataGridViewRow row in resultsDataGrid.Rows)
    if ((int)row.Cells["DataYN"].Value == 1)
    {
      row.Cells["Power"].ValueType = typeof(String);  
      row.Cells["Power"].Value = "No Data";  
    }
  </code></pre>
  
  <p>When compiling, I get an error message ' "<em>No Data" is not a valid value for Decimal</em>....'.</p>
  
  <p>The cell Value Type is clearly set and shown as string, yet the compiler thinks it is still decimal.
  I have tried all kinds of casting and conversion, but for no avail. </p>
  
  <ol>
  <li>Is this a compiler error ?</li>
  <li>Is there a workaround?</li>
  </ol>
  
  <p>samtal</p>