Server Error in '/' Application.

Cannot find table 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: Cannot find table 0.

Source Error:


Line 87:         int total = 0;
Line 88:         DataSet ds = com.GetTotalAgendaListeByTypeId(1, 9);
Line 89:         foreach (DataRow dr in ds.Tables[0].Rows)
Line 90:         {
Line 91:             total = int.Parse(dr[0].ToString());

Source File: d:\inetpub\vhosts\cityzens-25.package\cityzens.fr\wwwroot\agenda\av-cinema\avant-premiere-cinema.aspx.cs    Line: 89

Stack Trace:


[IndexOutOfRangeException: Cannot find table 0.]
   System.Data.DataTableCollection.get_Item(Int32 index) +114
   agenda_av_cinema_avant_premiere_cinema.CalculTotalRecords() in d:\inetpub\vhosts\cityzens-25.package\cityzens.fr\wwwroot\agenda\av-cinema\avant-premiere-cinema.aspx.cs:89
   agenda_av_cinema_avant_premiere_cinema.Page_Load(Object sender, EventArgs e) in d:\inetpub\vhosts\cityzens-25.package\cityzens.fr\wwwroot\agenda\av-cinema\avant-premiere-cinema.aspx.cs:27
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4082


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