Unable to access website

Question

1.00/5 (1 vote)

See more:

Request you to please help me with the below issue.. Website (alnadwacentre.com) is not loading... when I checked with godaddy techsupport, they told that it's a code issue and reach out to developer... our developer is not with our centre anymore ... hence thought of getting help here.

Below is the output from the website:

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 46:         DataSet ds = new DataSet();
Line 47:         ds = ObjAdd.DisplayPrayerTime();
Line 48:         lblPrayerTime.Text = ds.Tables[0].Rows[0][0].ToString();
Line 49:     }
Line 50:    

Source File: g:\pleskvhosts\alnadwacentre.com\httpdocs\Index.aspx.cs    Line: 48

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2519522
   System.Data.DataRowCollection.get_Item(Int32 index) +20
   Home.DisplayPrayerTimeTable() in g:\pleskvhosts\alnadwacentre.com\httpdocs\Index.aspx.cs:48
   Home.Page_Load(Object sender, EventArgs e) in g:\pleskvhosts\alnadwacentre.com\httpdocs\Index.aspx.cs:19
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533

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

--------------------------
Our index.aspx.cs file:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

public partial class Home : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DisplayLink();
            DisplayNews();
            DisplayPrayerTimeTable();
        }
    }
    public void DisplayLink()
    {
        string link = string.Empty;
        ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
        DataSet ds = new DataSet();
        ds = ObjAdd.DisplayLink();
        GV_Link.DataSource = ds;
        GV_Link.DataBind();
    }
    public void DisplayNews()
    {
        string News = string.Empty;
        ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
        DataSet ds = new DataSet();
        ds = ObjAdd.DisplayNewsTitel();
        NewsRepeater.DataSource = ds;
        NewsRepeater.DataBind();
        ObjAdd = null;
        ds.Dispose();
    }
    public void DisplayPrayerTimeTable()
    {
        string News = string.Empty;
        ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
        DataSet ds = new DataSet();
        ds = ObjAdd.DisplayPrayerTime();
        lblPrayerTime.Text = ds.Tables[0].Rows[0][0].ToString();
    }   
}

What I have tried:

I don't have developer skills, hence cannot check much... your help is very much appreciated.

Posted 16-Oct-23 4:44am

Mohammed Aarif Shaikh

Updated 25-Oct-23 10:39am

Deeksha Shenoy

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-10-16T05:03:00

Solution 1

Your code is assuming this line:

C#

ds = ObjAdd.DisplayPrayerTime();

is returning a bunch of rows. It does not check to see if any tables or rows have been returned by DisplayPrayerTime.

Why is it not returning rows? Nobody can tell you because you didn't show that the code for DisplayPrayerTime, nor any queries it's executing against a database, assuming there is one.

Posted 16-Oct-23 5:03am

Dave Kreskowiak

Comments

Mohammed Aarif Shaikh 17-Oct-23 9:19am

Thanks for you reply...

Please guide what I have to action here... as am not from developer background...

DO you want me to change/update anything in index.aspx.cs file ? please let me know what to update.

index.aspx.cs file content copied above in main question.

Dave Kreskowiak 17-Oct-23 9:35am

Read my post again: "Nobody can tell you because you didn't show that the code for DisplayPrayerTime, nor any queries it's executing against a database, assuming there is one."

Mohammed Aarif Shaikh 17-Oct-23 11:01am

isnt this is code -

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

public partial class Home : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DisplayLink();
DisplayNews();
DisplayPrayerTimeTable();
}
}
public void DisplayLink()
{
string link = string.Empty;
ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
DataSet ds = new DataSet();
ds = ObjAdd.DisplayLink();
GV_Link.DataSource = ds;
GV_Link.DataBind();
}
public void DisplayNews()
{
string News = string.Empty;
ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
DataSet ds = new DataSet();
ds = ObjAdd.DisplayNewsTitel();
NewsRepeater.DataSource = ds;
NewsRepeater.DataBind();
ObjAdd = null;
ds.Dispose();
}
public void DisplayPrayerTimeTable()
{
string News = string.Empty;
ImperoIT.ManagePrayerTime ObjAdd = new ImperoIT.ManagePrayerTime();
DataSet ds = new DataSet();
ds = ObjAdd.DisplayPrayerTime();
lblPrayerTime.Text = ds.Tables[0].Rows[0][0].ToString();
}

}

Dave Kreskowiak 17-Oct-23 12:35pm

Sigh. Reporting the exact same code you originally posted doesn't change anything.

What you DID NOT post is the code for whatever "DisplayPrayerTime()" is. That's where the problem is going to be.

Member 16142570 · Answer 2 · 2023-11-17T13:04:00

Solution 3

your code wants to check if there is something in the table before you try to pass it to a value because if it is empty it will give you an index out of bounds error eg. if table size >= 0 ds = table[0] rows[0][0] else break/continue code

Posted 17-Nov-23 13:04pm

Member 16142570

Comments

Richard Deeming 20-Nov-23 4:20am

As already explained in solution 1 last month.