Server Error in '/' Application.

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.(SELECT RSAAT FROM RANDEVULAR WHERE RTARIH='29.03.2024' AND RSAAT='09:00-09:30')

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.(SELECT RSAAT FROM RANDEVULAR WHERE RTARIH='29.03.2024' AND RSAAT='09:00-09:30')

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.(SELECT RSAAT FROM RANDEVULAR WHERE RTARIH='29.03.2024' AND RSAAT='09:00-09:30')]
   WebApplication3.Fonksiyon.GetDataTable(String Sql) in D:\2 - PROJELER\kubraMehmetoglu\WebApplication3\Fonksiyon.cs:55
   WebApplication3.Fonksiyon.GetDataRow(String Sql) in D:\2 - PROJELER\kubraMehmetoglu\WebApplication3\Fonksiyon.cs:86
   WebApplication3.eRandevu1.bosSaatleriGetir() in D:\2 - PROJELER\kubraMehmetoglu\WebApplication3\eRandevu.aspx.cs:153
   WebApplication3.eRandevu1.Page_Load(Object sender, EventArgs e) in D:\2 - PROJELER\kubraMehmetoglu\WebApplication3\eRandevu.aspx.cs:39
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0