title: How do I Display row values in c# using access database?
body: <p>I am triyng to Make a program which shows the user random english words(taken from an access DB) and requires him to write the hebrew defenition of the word.
  I managed to program this very easily using "cells(X,Y)" in excel VBA... But now when I am triyng to do it in c# and access I am getting a bit lost.
  I managed to get the reader working - the question is - how to tell it read only a specific row in my project?
  I.E. - it gets a random number of 5, and then it shows the value of the english word in row 5, and expects to recieve the hebrew word in row 5 as an answer.</p>
  
  <p>this is what i currently achieved:
  <pre>
       private void button1_Click(object sender, EventArgs e)
              {
              string conStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Words\WordsDatabase.accdb";
              string mySelect = "SELECT english,hebrew FROM study";
              OleDbConnection dbConnect = new OleDbConnection();
              dbConnect.ConnectionString = conStr;
              dbConnect.Open();
              OleDbCommand dbCmd = new OleDbCommand(mySelect, dbConnect);
              OleDbDataReader dbReader = dbCmd.ExecuteReader();</p>
  
  <code>      while (dbReader.Read())
          {
          textBox1.Text +=  dbReader.GetValue(0).ToString() + "\r\n";
          textBox2.Text += dbReader.GetValue(1).ToString() + "\r\n";
  
          }
  
  
      }
  </code></pre>
  
  <p>
  Thanks a lot,
  Barak.</p>