title: select all from access and place in string
body: <p>I'm having trouble selecting all items from my access database. I want to select the data in the entire row and keep it in a string, separating each item by a ";". Below is the code i have that will give me the column i specify, but i want all the data in the row. </p>
  
  <pre><code>con.Open();
  type= checkBox49.Text;
  
  String str = "Select * from distro where type='" + type + "'";
  cmd = new OleDbCommand(str, con);
  dr = cmd.ExecuteReader();
  
  if (dr.Read())
  {
     str2 = dr.GetString(1);
  
  } 
  </code></pre>