Server Error in '/' Application.

Conversion from type 'DBNull' to type 'String' is not valid.

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.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.

Source Error:


Line 207:                '   If Action = 0 Then
Line 208:                'einai imerominia ?
Line 209:                If DateTime.TryParse(.Rows(F)(1), TempDate) Then
Line 210:                    Calendar1.SelectedDates.Add(TempDate)
Line 211:

Source File: D:\INETPUB\VHOSTS\corfuactivities.com\httpdocs\corfu_activities_dates.aspx.vb    Line: 209

Stack Trace:


[InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) +1307492
   csla_dates.Bres_Booked_Imerominies() in D:\INETPUB\VHOSTS\corfuactivities.com\httpdocs\corfu_activities_dates.aspx.vb:209
   csla_dates.Csla_dates_Init(Object sender, EventArgs e) in D:\INETPUB\VHOSTS\corfuactivities.com\httpdocs\corfu_activities_dates.aspx.vb:67
   System.Web.UI.Control.OnInit(EventArgs e) +97
   System.Web.UI.Page.OnInit(EventArgs e) +14
   System.Web.UI.Control.InitRecursive(Control namingContainer) +142
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +416


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