title: c# OleDbDataAdapter; occurrence number?
body: <p>I've done little bits of database stuff in the past, including SQL (although I don't know which variations they were); in one of them I'm sure there was an 'occnum' keyword or similar, which allowed a row in a table without unique fields to be addressed by index?</p>
  
  <p>In my current situation, a few years and an entirely different workplace later, I'm faced with writing a C# application that allows a company specific Access database to be edited. This database lacks primary keys, so I've tried to find a similar 'occurrence number' functionality to edit specific rows with and haven't found anything. Changing the database structure is not an option, and none of the fields are unique.</p>
  
  <p>As an example, I use an OleDbDataAdapter to query some rows as follows:</p>
  
  <pre><code>        List&lt;string&gt; result = new List&lt;string&gt;();
  
          DataSet dataSet = new DataSet();
          OleDbDataAdapter oleDBA = new OleDbDataAdapter(new OleDbCommand("SELECT " + FIELDNAME_ITEMDATA_TAG + " FROM " + TABLENAME_ITEMDATA + " WHERE " + FIELDNAME_ITEMDATA_AREANUMBER + " = " + Area.ToString(), oleDbConnection));
          oleDBA.Fill(dataSet, "ResourceString");
  
          foreach (DataRow dr in dataSet.Tables[0].Rows)
          {
              result.Add(dr.ItemArray[0].ToString());
          }
  </code></pre>
  
  <p>The string list is then used to populate a ListBox. When entries on the list box are populated, I would like to be able to query an individual row by it's occurrence number, something like:</p>
  
  <pre><code>"SELECT " + FIELDNAME_ITEMDATA_TAG + " FROM " + TABLENAME_ITEMDATA + " WHERE " + FIELDNAME_ITEMDATA_AREANUMBER + " = " + Area.ToString(), oleDbConnection AND OCCNUM = " + OccNum
  </code></pre>
  
  <p>Is this doable? Have I just failed to find the correct keyword?</p>