title: vb.net as I query Access database and display it in listview?
body: <p>I'm creating a form where I can do the following:
  <a href="https://i.stack.imgur.com/823bh.png" rel="nofollow noreferrer">please see the image </a>
   As you can see, I have a <strong>txt_id_up</strong> and <strong>txt_id_dw</strong>
  in the database I want to make the following query.</p>
  
  <pre><code>SELECT * FROM Tabla1
  WHERE ID BETWEEN 3 AND 7;
  </code></pre>
  
  <p>where <strong>txt_id_up</strong> = 3, and txt_id_dw = 7;</p>
  
  <pre><code>    Dim connection As OleDbConnection
      Dim command As OleDbCommand
      Dim data_reader As OleDbDataReader
  
      '------------------------------
      'connect to ms.access database
      connection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data 
      Source= data\base.accdb;Persist Security Info=False")
      connection.Open()
      'reading data from Tabla1 table
      command = New OleDbCommand("SELECT * FROM Tabla1", connection)
      data_reader = command.ExecuteReader
      '----------------------------------
      'here the code to show in listview1 is missing
      '----------------------------------
  </code></pre>
  
  <p>and in passing I would like to ask another question, can only the following columns be shown in <strong>listview</strong>?
  <strong>Name
  Account</strong></p>
  
  <p>I clarify that I use the <strong>datagridview</strong> to see it in general and the <strong>listview for queries</strong></p>