PC Review


Reply
Thread Tools Rate Thread

Dataset table Sequence issue

 
 
Rnes
Guest
Posts: n/a
 
      4th Nov 2010
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)).
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
XML Dataset Update sequence? Dale Microsoft ADO .NET 0 5th Mar 2005 09:51 PM
Revisiting the issue of "Filling the dataset with a table with same name as in another class" Earl Microsoft ADO .NET 3 6th Jul 2004 05:28 PM
How to maintain XML element sequence when serializing/deserializing using DataSet Atul Agarwal Microsoft ADO .NET 2 17th Nov 2003 05:53 PM
copying a datatable content from an untyped dataset into a table which is inside a typed dataset Nedu N Microsoft ASP .NET 2 31st Oct 2003 01:05 PM
Parse table from one dataset and create new dataset using this table moondaddy Microsoft ADO .NET 2 22nd Oct 2003 11:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:03 AM.