title: How do I use IF/ELSE or CASE In DataColumn.Expression?
body: <p>I have a table with 1 column: 'Status' 
  I want to add in another column named 'Action', its value will be as follow: if Status = 'Yes' Then Action = 'Go', otherwise, Action = 'Stop'. I used this following code to add in column 'Action' but it didn't work:</p>
  
  <pre><code>myDataTable.Columns.Add("Action", typeof(string), "IF [Status] = 'Yes' THEN 'Go' ELSE 'Stop' END");
  </code></pre>