Server Error in '/BidWilly' Application.

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 5166:        DataRow dr = (DataRow)Session["drMySession"];
Line 5167:
Line 5168:        if (Convert.ToInt32(dr["user_id"].ToString()) == 311)
Line 5169:        {
Line 5170:            sortsql = "Select 'https://perfectliving.org/app/lawnschedule.aspx?bwtype=1&lawn_care_id='+ CAST(lawn_care_id as varchar(10)) as Website, lawn_care_id, last_completed_date,service_day,start_date, frequency,client_name as name,contact_number as phone,house_number + ' ' + street_name + ' ' + city + ' ' + zip_code as Address,provider_pay as PAY, date_added, latitude, longitude, '0.00 miles' as distance, sequence_order, lot_size,route_notes,route_notify,valued_customer,route_shrubs,route_shrubspay,client_next_service_notes,shrubs_completed_ind, (Select NHA_USER.full_name from NHA_User where NHA_User.user_id=cust_lawn_care.employee_id) as employeename, routeday, routesort from cust_lawn_care where lawn_provider_id=@lawn_provider_id order by sequence_order";

Source File: c:\Domains\perfectliving.org\BidWilly\professionalAccount.aspx.cs    Line: 5168

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
   professionalAccount.PopulateLawnRoute() in c:\Domains\perfectliving.org\BidWilly\professionalAccount.aspx.cs:5168
   professionalAccount.Page_Load(Object sender, EventArgs e) in c:\Domains\perfectliving.org\BidWilly\professionalAccount.aspx.cs:130
   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