I have a SQL stored procedure that creates 4 tables. So when I fill
the dataset in my code "Sqladapter.Fill(ds)", I should see 4
tables ... ds.tables(0), ds.tables(1) ... ds.tables(3). This has
been working for ever. Now for some reason. table 0 and table 1 are
switched in sequence.
When I look at the list of table names for the dataset is ("Table1",
"Table", "Table2", and "Table3") so the order for table "0" and "1"
have switched their sequence. When I try to acccess ds.tables(1) I am
actually reading data from table 0.
Has anyone ever seen this before? I had to modify my program to use
the table name instead of the table number (ds.tables("Table") instead
of ds.tables(0)).
|