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 128:                         //  DataTable dtpen = Class1.GetRecord("select * from ProductTB where P_Id=" + refilllist[i] + "");
Line 129:                           DataTable dtpen = Class1.GetRecord("EXEC GetProductTB 'GetById'," + int.Parse(refilllist[i]));
Line 130:                           z = dtpen.Rows[0]["P_Id"].ToString();
Line 131:
Line 132:                           //if (refillid.Contains(z) == true)

Source File: c:\inetpub\vhosts\addpens.com\httpdocs\product_gelrefilldetails.aspx.cs    Line: 130

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2129972
   System.Data.DataRowCollection.get_Item(Int32 index) +22
   product_gelrefilldetails.ProductBindById(Int32 pid) in c:\inetpub\vhosts\addpens.com\httpdocs\product_gelrefilldetails.aspx.cs:130
   product_gelrefilldetails.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\addpens.com\httpdocs\product_gelrefilldetails.aspx.cs:28
   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.4075.0