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 342:        da.SelectCommand.CommandTimeout = 200000;
Line 343:        da.Fill(dt);
Line 344:        return dt.Rows[0]["cOtherName"].ToString();
Line 345:    }
Line 346:

Source File: c:\inetpub\vhosts\lucintel.com\httpdocs\App_Code\GetMasterData.cs    Line: 344

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2136731
   System.Data.DataRowCollection.get_Item(Int32 index) +21
   GetMasterData.GetCategoryNew(String Cond, String Orderd) in c:\inetpub\vhosts\lucintel.com\httpdocs\App_Code\GetMasterData.cs:344
   general_report.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\lucintel.com\httpdocs\general_report.aspx.cs:58
   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.4087.0