title: binding do not work in C# WPF with oracle
body: <p>I am using <code>DataGrid</code> control from <code>WPF</code> to present data from <code>Oracle</code> database. I wrote these lines:  </p>
  
  <p>XAML file:</p>
  
  <pre><code>&lt;DataGrid AutoGenerateColumns="True" 
        Height="446" HorizontalAlignment="Left" Margin="16,63,0,0" Name="systemDataGrid" VerticalAlignment="Top" Width="636"&gt;
      &lt;DataGrid.Columns&gt;
          &lt;DataGridTextColumn Binding="{Binding  ID}" Header="ID" MaxWidth="50" /&gt;
          &lt;DataGridTextColumn Binding="{Binding SYSTEM_NAME}" Header="Name" /&gt;
          &lt;DataGridTextColumn Binding="{Binding SYSTEM_DESC}" Header="Description"  /&gt;
          &lt;DataGridTextColumn Binding="{Binding SYSTEM_CREATED}" Header="Created" /&gt;
      &lt;/DataGrid.Columns&gt;
  &lt;/DataGrid&gt;
  </code></pre>
  
  <p>CS file:</p>
  
  <pre><code>string sqlStr = "select ID, System_Name, System_Desc, System_Created from system";
  OracleDataAdapter dataAdapter = new OracleDataAdapter(sqlStr, db.Connection);
  DataSet systemDataSet = new DataSet();
  dataAdapter.Fill(systemDataSet);
  if(systemDataSet.Tables[0].Rows.Count &gt; 0)
  {
      systemDataGrid.ItemsSource = systemDataSet.Tables[0].DefaultView;
  }
  </code></pre>
  
  <p>But the data from database cannot be displayed right there except the ID. And there is only ID shown if I turn off AutoGenerateColumns.</p>
  
  <p>Sorry that I cannot post image. Please view it at <a href="http://i.stack.imgur.com/0Z91C.png" rel="nofollow">http://i.stack.imgur.com/0Z91C.png</a> </p>
  
  <p>The field names in <code>Oracle</code> is like <code>SYSTEM_NAME</code>, <code>SYSTEM_DESC</code> etc. And I have tried <code>{Binding SYSTEMNAME}</code> <code>{Binding SYSTEM_NAME}</code> <code>{Binding Path=SYSTEM_NAME}</code> etc, no one works.</p>
  
  <p>Is there something wrong with my code, or it's the underscore in the field name?</p>
  
  <hr>
  
  <h2>Update:</h2>
  
  <p>If I use <code>"select ID, System_Name systemname, System_Desc systemdesc, System_Created systemcreated from system";</code>, <code>{Binding SYSTEMNAME}</code> works fine, so there is definitely
  something wrong with the underscore, but how?</p>
  
  <p>Thank you for any information.</p>
  
  <h2>Update:</h2>
  
  <p>It turns out that I was using <code>{Binding System_Name}</code> as the field name in SQL when I got nothing, and it worked if use <code>{Binding SYSTEM_NAME}</code>. Thank you guys and sorry for my mistake. </p>
  
  <h3>You have to use all upper case.</h3>