how many tables can a dataset hold?

[leangross]

I created tha dataset and fill it will data from 3 different table. When I tried getting the number of row on the third table, dataset.table(2) it says, "can not find table 2"

If i only have two tables in dataset i can read the second table, dataset.table(1)

 

[chrissie1]

A dataset can hold more then 2 tables.

I couldn't find an exact number.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[SqueakinSweep]

Sounds like table2 hasnt been filled for some reason. You can reference the table by name also ie ds.tables("Table2")

Another useful debugging trick is to write the dataset out to an xml file on your local disk to see what is in there.
ds.writexml("c:\temp\debug.xml")



Sweep
...if it works dont mess with it