ASP.NET C# getdate() with startdate and enddate SQL query

 select * from icms_TransferDrive where DefaultDrive= '1' and StartDate<=getdate() and enddate>=getdate()