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 100:                cmd.CommandText = sql
Line 101:                ds = dbFunc.getDataSet(cmd)
Line 102:                lblCatName.Text = ds.Tables(0).Rows(0)("cName").ToString
Line 103:            Else
Line 104:                sql += "(itm_detail.sID = " & currentAuction & " AND itm_detail.catID = " & currentCat & " AND itm_detail.idActive <> 0 AND itm_detail.idStatus <> 1) order by idShootPrice DESC, itmName ASC"

Source File: C:\Inetpub\vhosts\teamauctions.com\httpdocs\auction-category.aspx.vb    Line: 102

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2440285
   System.Data.DataRowCollection.get_Item(Int32 index) +19
   auction_category.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\teamauctions.com\httpdocs\auction-category.aspx.vb:102
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


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