title: How to select the first row data of the database from the data table using C#?
body: <p>How can I select the first row of the data in the datatable? And display the content on a labelbox, and radiobuttons?</p>
  
  <pre><code>OleDbDataAdapter dAdap = new OleDbDataAdapter(command);
  DataTable dTable = new DataTable();
  dAdap.Fill(dTable);
  foreach(DataRow row in dTable.Rows)
  {
      question = row["QUESTION"].ToString();
      c1 = row["C1"].ToString();
      c2 = row["C2"].ToString();
      c3 = row["C3"].ToString();
      c4 = row["C4"].ToString();
      ans = row["ANSWER"].ToString(); 
  }
  lblQuest.Text = question;
  btnA.Text = c1;
  btnB.Text = c2;
  btnC.Text = c3;
  btnD.Text = c4;
  </code></pre>
  
  <p>I tried this code, but it only displays the last row. Also when I try to rerun the query. It didn't refresh/replace/overwrite the values, it only displays the last row of the first query.</p>
  
  <p>edit:</p>
  
  <pre><code>i = 0;
  x = 0;
  lblQuest.Text = dTable.Rows[i].Field&lt;string&gt;(x);
  btnA.Text = dTable.Rows[i].Field&lt;string&gt;(x + 1);
  btnB.Text = dTable.Rows[i].Field&lt;string&gt;(x + 2);
  btnC.Text = dTable.Rows[i].Field&lt;string&gt;(x + 3);
  btnD.Text = dTable.Rows[i].Field&lt;string&gt;(x + 4);
  </code></pre>