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 217:        MyCommand.Fill(DS, "maxID")
Line 218:
Line 219:        getCategoryID = DS.Tables(0).Rows(0).Item(0)
Line 220:        DS.Clear()
Line 221:        MyConnection.Close()

Source File: C:\Inetpub\vhosts\papakostas.com.gr\httpdocs\vehicleDetails.aspx.vb    Line: 219

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2562189
   System.Data.RBTree`1.get_Item(Int32 index) +16
   System.Data.DataRowCollection.get_Item(Int32 index) +16
   _vehicleDetails.getCategoryID() in C:\Inetpub\vhosts\papakostas.com.gr\httpdocs\vehicleDetails.aspx.vb:219
   _vehicleDetails.populateVehicleExtras() in C:\Inetpub\vhosts\papakostas.com.gr\httpdocs\vehicleDetails.aspx.vb:226
   _vehicleDetails.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\papakostas.com.gr\httpdocs\vehicleDetails.aspx.vb:635
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428


Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062