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 293:        Dim DS As DataSet
Line 294:        DS = mx1Data.mx1DataSet("SELECT materias.codigo, Titulo, data, txtchamada, fotochamada, categoria FROM materias, categorias WHERE categ = " & cat & " AND categorias.codigo = categ  AND disp=1 ORDER BY Codigo DESC LIMIT " & iniP & "," & PageSize)        'Dim Categoria As String = mx1Data.SelectEscalar("SELECT categoria FROM categorias WHERE codigo=" & cat)
Line 295:        Dim Categoria As String = DS.Tables(0).Rows(0)("categoria")
Line 296:
Line 297:        strReturn.AppendLine("<div id=""chamadaartig"">")

Source File: D:\host\motox\web\publixw\Default.aspx.vb    Line: 295

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2136139
   System.Data.DataRowCollection.get_Item(Int32 index) +21
   publix_Default.ExibeCategoria(Int32 cat) in D:\host\motox\web\publixw\Default.aspx.vb:295
   publix_Default.MostraCategoria(Int32 cat) in D:\host\motox\web\publixw\Default.aspx.vb:270
   publix_Default.Page_load() in D:\host\motox\web\publixw\Default.aspx.vb:69
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +9873237
   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.3930.0