title: how to get data from my database using dates between two dates
body: <p>My work is working it outputs my table column names in the DataGridView but my data doesn't show up is their someting im missing here? </p>
  
  <pre><code>        private void button1_Click(object sender, EventArgs e)
          {
              DateTime dt = this.dateTimePicker1.Value.Date;
  
              DateTime dt2 = this.dateTimePicker1.Value.Date;
  
              command.CommandType = CommandType.Text; 
             command.CommandText = ("SELECT * FROM BillingSystem WHERE DateOfTransaction BETWEEN #" + dt.ToShortDateString() + "# AND #" + dt2.ToShortDateString() + "#");
  
             OleDbDataAdapter adapter = new OleDbDataAdapter(command.CommandText, connectionBilling);
             DataSet ds = new DataSet();
  
             adapter.Fill(ds);
             dataGridView1.DataSource = ds.Tables[0];
             connectionBilling.Close();
  
              }
  </code></pre>