There is no row at position 0.

Server Error in '/' Application.

There is no row at position 0.

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.IndexOutOfRangeException: There is no row at position 0.

Source Error:


Line 48:             var sql = string.Format("SELECT ProductID FROM CONTENT_Product WHERE ProductName = '{0}'", Request["productName"].Replace("_", "/").Replace("-----"," - ").Replace("---"," -").Replace("--", " "));
Line 49:             var result = ConnectionHelper.ExecuteQuery(sql, null, QueryTypeEnum.SQLQuery);
Line 50:             productId = Int32.Parse(result.Tables[0].Rows[0][0].ToString());
Line 51:         }
Line 52:         else if (Int32.TryParse(Request["categoryId"],out tmp))

Source File: e:\www\component.omron.eu_ver10\CMSWebParts\Omron\BreadcrumbForProducts.ascx.cs    Line: 50

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2708437
   System.Data.DataRowCollection.get_Item(Int32 index) +19
   CMSWebParts_Omron_BreadcrumbForProducts.Page_Load(Object sender, EventArgs e) in e:\www\component.omron.eu_ver10\CMSWebParts\Omron\BreadcrumbForProducts.ascx.cs:50
   System.Web.UI.Control.OnLoad(EventArgs e) +109
   CMS.Base.Web.UI.AbstractUserControl.OnLoad(EventArgs e) +71
   CMS.PortalEngine.Web.UI.CMSAbstractWebPart.OnLoad(EventArgs e) +212
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Control.LoadRecursive() +165
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4498


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