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 44: 
Line 45:                 Me.lblAuctionName.Text = .Rows(0)("pb_Name")
Line 46:                 Me.lblLocation.Text = .Rows(0)("saleLocation")
Line 47:                 Dim saleD As Date = .Rows(0)("saleDate")
Line 48:                 ' Me.lblAuctionTitle.Text = .Rows(0)("saleName") & "<br/>" & saleD.ToString("MMMM dd, yyyy") & " at <span class='coloraccent1'>" & .Rows(0)("saleLocation") & "</span>"

Source File: G:\PleskVhosts\vjvauction.com\httpdocs\sale-detail-purebred.aspx.vb    Line: 46

Stack Trace:


[InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value) +1307492
   sale_detail_purebred.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\vjvauction.com\httpdocs\sale-detail-purebred.aspx.vb:46
   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