title: How to get multiple rows from access database
body: <p>I am trying to store each row of a access database, based on column <code>Veh_ID</code>. The found data may or may not be based on multiple rows. The code I am currently using can copy single row but if there are multiple results I can only get the first result. Can anyone please help me on this? I am noob when it comes to database. I tried to search Google but no one seems to be needing what I need. Here's the code I'm using:</p>
  
  <pre><code>string cmd1 = "SELECT * FROM Veh_checkup WHERE Veh_ID = " + veh_idd + "";
  OleDbCommand cmd = new OleDbCommand(cmd1, con);            
  OleDbDataReader read = cmd.ExecuteReader();
  read.Read();
  veh_id=null;
  
  int i=0;
  
  foreach (var a in read)
  {
      try
      {
          veh_id = veh_id + " " + read[i].ToString();
      }
      catch { }
      i++;
  }
  </code></pre>