Retrieving a dataset (no error on localhost but error online)

Question

0.00/5 (No votes)

See more:

dsData = Data.GetDataSet(sqlData, GlobalParameters.conn)
            For Each dr As DataRow In dsData.Tables(0).Rows

The lines above, for some reason (I'm completely clueless) work perfectly when I'm running the site on localhost, but it won't work when uploaded onto a server. it for some reason comes up with the following error message even though the sql query is correct (and its been tested)

System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at Website.AdAppointments.btnSendAppointments_Click(Object sender, EventArgs e) in (FILE LOCATION):line 224

Line 224 is the beginning of the For loop.

Thanks a lot :)

Posted 24-Apr-11 2:44am

Peter Liaros

Updated 24-Apr-11 2:46am

v2

Add a Solution

Comments

Ed Nutting 24-Apr-11 9:16am

Is the data given to your server the same as the data being returned to your local host? Do you have a permissions problem on your server that returns a blank collection of tables or similar? Have you tried simply getting your page to dispay how many tables are in the dsData.Tables collection?

3 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)

Om Prakash Pant · Answer 1 · 2011-04-24T03:23:00

Solution 1

It is probably trying to bind a data table to a dataset which does not have a table because no results were returned.

before using the datatables check for its existance:

VB

if (DataSet1.Tables.Count > 0)

Posted 24-Apr-11 3:23am

Om Prakash Pant

Comments

Peter Liaros 24-Apr-11 18:15pm

okay... ill give that a go

Peter Liaros 24-Apr-11 18:41pm

yeh, no table exists, according to that line.

Om Prakash Pant 26-Apr-11 2:59am

Try :
dsData = Data.GetDataSet(sqlData, GlobalParameters.conn)
if (dsData.Tables.Count > 0)
For Each dr As DataRow In dsData.Tables(0).Rows
.
.

Sandeep Mewara · Answer 2 · 2011-04-24T07:29:00

System.IndexOutOfRangeException: Cannot find table 0. at
This error has nothing to do with server or local environment. It simple means that the dataset returned has no tables and thus when you try to access a table(assuming it is there), it throws an error.

Though, it's already suggested that make sure you check if the table exists or not before using it. Further, just considering any environemnt thing, it might be that the connection string is not proper(is wrong) and the dataset is not returned/formed correctly and thus you face an error. Just make sure that the data is returned as in local environment and then it should be fine.

Wonde Tadesse · Answer 3 · 2011-04-24T10:36:00

Solution 3

The dataset is not returning values. May be check your database connection string whether it points to the wright database.

Posted 24-Apr-11 10:36am

Wonde Tadesse

Comments

Peter Liaros 24-Apr-11 18:13pm

I run many SQL query's on this site and they all work.. It's just this page that decides to be a pain in the ass, so its nothing wrong with the connection string

Retrieving a dataset (no error on localhost but error online)

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us