title: Reading or updating a table fails in Firebird database
body: <p>I have created a table in firebird name <strong>emp</strong> and I am trying to get all the data from that table into a datatable in c# using <strong>FbDataAdapter</strong>.</p>
  
  <p>But in that datatable I am only getting the column names. I am not getting the values. The table has 3 rows.</p>
  
  <pre><code>DataTable dt = new DataTable();
  FbDataAdapter adapter1 = new FbDataAdapter("select * from emp", con);
  adapter1.Fill(dt);
  </code></pre>
  
  <p>Code used for reading the data from that emp table in firebird. But in that table am having these values:</p>
  
  <p><img src="https://i.stack.imgur.com/sCkgS.png" alt="enter image description here"></p>
  
  <p>but in that <strong>dt</strong> it shows only those columnnames :( :( whys its behaving so...!!</p>
  
  <p>Then i have inserted some values into that same database table by following command</p>
  
  <pre><code>FbCommand cmd = new FbCommand("INSERT INTO emp VALUES ('11','X')", con);
  int ds =cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>and then when i again see in the <strong>dt</strong> it shows only the values that are inserted through above SQL query.</p>