Server Error in '/' 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 39:         name = cnn.ExecuteScalar("select MainCategoryName  from  M_CategoryMaster where MainCategoryid=" + Request.QueryString["MainCategoryid"] + "").ToString();
Line 40:         if (Request.QueryString["SubCategoryid"] != null)
Line 41:             subname = cnn.ExecuteScalar("select SubCategoryName from subcategory where id=" + Request.QueryString["SubCategoryid"] + "").ToString();
Line 42:         string s= "select productid,productname,image,sale,(select top 1 coalesce(urate,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as price,(select  top 1 coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as discount,(select top 1 coalesce(urate,0)-coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID)as price1,Case When Cast(rts as Date)>=Cast(GetDate()-10 as Date) Then 1 Else 0 End as NewStatus,sale from product where active=1  " + cond + " " + cond1 + " ";
Line 43:         DataTable Dtt = cnn.FillTable("select productid,productname,image,sale,(select top 1 coalesce(urate,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as price,(select  top 1 coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as discount,(select top 1 coalesce(urate,0)-coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID)as price1,Case When Cast(rts as Date)>=Cast(GetDate()-10 as Date) Then 1 Else 0 End as NewStatus,sale from product where active=1  " + cond + " " + cond1 + " ", "Detail");

Source File: c:\HostingSpaces\artandcraftfurniture\artandcraftfurniture.com\wwwroot\Category.aspx.cs    Line: 41

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
   Category.ads(String cond, String cond1) in c:\HostingSpaces\artandcraftfurniture\artandcraftfurniture.com\wwwroot\Category.aspx.cs:41
   Category.Page_Load(Object sender, EventArgs e) in c:\HostingSpaces\artandcraftfurniture\artandcraftfurniture.com\wwwroot\Category.aspx.cs:32
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


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