C# MSSQL tarih arası veri çekme

datalar.Reset();
           AraSecilen = "";


            var lst = listBox3.SelectedItems.Cast<DataRowView>();
            foreach (var item in lst)
            {
                AraSecilen = item.Row[0].ToString();

            }
         

            Baglanti Baglan = new Baglanti();
            Baglan.Connection_Today();



           SqlDataAdapter PersonelAra = new SqlDataAdapter("SQL SORGUSU EKLEDİĞİMDE HATA VERİYOR", Baglanti.conn);

            PersonelAra.Fill(datalar);
            dataGridView1.DataSource = datalar.Tables[0];
            dataGridView1.Columns[0].HeaderText = "ID";
            dataGridView1.Columns[1].HeaderText = "Bölümü";
            dataGridView1.Columns[2].HeaderText = "Adı Soyadı";
            dataGridView1.Columns[3].HeaderText = "Tarih";
            dataGridView1.Columns[4].HeaderText = "Giriş";
            dataGridView1.Columns[5].HeaderText = "Çıkış";
            Baglanti.conn.Close();

SELECT * FROM tablo_ismi;