DateTime dt2 = new DateTime(); DateTime dt4 = DateTime.Now; string command8 = "SELECT * FROM Tbar WHERE GIORNO >= #" + dt2.Date + "# AND GIORNO <= #" + dt4.Date + "#";