title: XamDataGrid dynamic fields format poorly
body: <p>So I have a simple window which contains only a XamDataGrid that holds preview data of a dynamic query generated at run-time...</p>
  
  <pre><code>public partial class DataPreview : Window
  {
      public DataTable Data { get; set; }
      public DataPreview(string SQL)
      {
          InitializeComponent();
  
          this.DataContext = this;
          Data = DatabaseManager.ExecuteQuery(SQL);
      }
  }
  </code></pre>
  
  <p>I have databound to the datasource of the XamDataGrid...</p>
  
  <pre><code>&lt;igDP:XamDataGrid DataSource="{Binding Data}" ScrollingMode="Immediate"&gt;
       &lt;igDP:XamDataGrid.FieldSettings&gt;
            &lt;igDP:FieldSettings
               AllowEdit="False"/&gt;
       &lt;/igDP:XamDataGrid.FieldSettings&gt;
  &lt;/igDP:XamDataGrid&gt;
  </code></pre>
  
  <p>Now this all works fine, the problem is the datatype of the editor in the XamDataGrid does not match the datatype of the field sometimes.  For example all numerics show with a dollar sign.  I tried to add this line...</p>
  
  <pre><code>EditAsType="{x:Type sys:String}"
  </code></pre>
  
  <p>Which fixed everything except actual currency amounts, which now display as xx.xxxx with no dollar sign.  All the solutions I have found online seem to edit the field's directly in the xaml, but since the fields are all dynamic this is not an option.  Is there something I can do to set the editors correctly in the xaml?  Or some routine I can do in the code to massage the data into displaying correctly from the XamDataGrid?  Can anyone share any code using XamDataGrid in a related way with all dynamic columns, but able to format them correctly based on datatype?</p>