System.IndexOutOfRangeExceptio...

Question

0.00/5 (No votes)

See more:

My asp.net web application is working fine on the localhost but when I go to the live server I am getting this error: System.IndexOutOfRangeException: Cannot find table 0. on this line of code: if (ds.Tables[0].Rows.Count > 0) means dataset does nnot have the table[0], how do I resolve this issue, please help me

Thanks in advance

C#

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 41:                 else { OID = Request.QueryString["u"].ToString(); }
Line 42:               DataSet ds = myAdmin.getPassCodeAMIN(OID);
Line 43:                     if (ds.Tables[0].Rows.Count > 0)
Line 44:                         {
Line 45: 


Source File: c:\inetpub\vhosts\ip-pabx.com\httpdocs\LoginAction.aspx.cs    Line: 43

Stack Trace:

Posted 4-Jul-15 0:34am

Member 7985285

Add a Solution

Comments

aarif moh shaikh 4-Jul-15 6:50am

Where's your getPassCodeAMIN() function?

There in no table in ds. that's why it giving error.

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)

DamithSL · Answer 1 · 2015-07-04T00:55:00

Solution 1

check table count first

C#

if (ds.Tables.Count>0 && ds.Tables[0].Rows.Count > 0)
{

}

you better debug and check why getPassCodeAMIN method not returning datatable as you expected. in case of that method return empty data set you can add above validation to avoid exception

Posted 4-Jul-15 0:55am

DamithSL

Ashraf Sada · Answer 2 · 2015-07-04T05:37:00

The dataset you are using is empty, because you are using wrong approach to load data into the dataset, to load data into dataset see this example:
First connect to the database you are working on:
Assuming it is sql server database.

C#

string strCon = "Data source = yourDataSource; Initial Catalog = DatabaseName; Integrated Security = SSPI;"; // for example if you are using windows authentication
            SqlConnection Conn = new SqlConnection(strCon);
            string strCmd = "select * from Company;";
            SqlDataAdapter sda = new SqlDataAdapter(strCmd, Conn);

            DataSet ds = new DataSet();
            sda.Fill(ds);
            
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Console.WriteLine(dr["compName"]);
            }