There's an "can't find table 0" error

Question

4.00/5 (1 vote)

See more:

Anything that i did did'nt help, tried to put an

C#

int x=DataBase.ds.Tables.Count;
if(x>0)
{ 
//rest of code
}

The problem is mainly in the for, and does'nt happen in any other forms(while using Tables[0])...
I'm not describing about the content because its not relevant, I need a solution that works in any code.

What I have tried:

C#

<pre>    

                {
                    for (int i1 = 0; i1 < DataBase.ds.Tables[0].Rows.Count; i1++)
                    {


                        if (//some condition)
                        {
                              //some code
                        }
                    }
                }

Posted 28-Dec-19 14:29pm

Eliav Ben Shitrit

Updated 29-Dec-19 5:52am

Add a Solution

Comments

Richard MacCutchan 29-Dec-19 4:16am

Are you certain that the dataset has been initialised correctly at that point?

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)

dnxit · Answer 1 · 2019-12-28T21:26:00

Better to check for all these

C#

if(ds != null)                  // see if data set is not null
if(ds.Tables.Count > 0 )        // see if your data set has tables
if(ds.Tables[0].Rows.Count > 0)  //see if first table in your data set has any rows

Or you can create a generic function to see if your dataset is Empty like

C#

bool IsEmpty(DataSet dataSet)
{
    return !dataSet.Tables.Cast<DataTable>().Any(x => x.DefaultView.Count > 0);
}

also The Fill() method of DataAdapter returns the # of rows added for the first table in the DataSet.

Wendelius · Answer 2 · 2019-12-29T05:53:00

Based on the error, the data set has no tables when you execute the for loop. Since you try to use the first table (index 0) from the dataset you get the error message.

So use the debugger to go through the code which populates the dataset. Check for example if
- Populating code is omitted because of a condition
- The for loop is called before population occurs
- When populated no data is found etc.

There's an "can't find table 0" error

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0