Bill,

>The idea was to have the names already in place so the Tables could be accessed by name ...

Two words ... Typed DataSets ... <g>

~~Bonnie



>Hi Kevin,
>
>Yeah, I know I could name them after the fact. :-) The idea was to have the names already in place so the Tables could be accessed by name instead of ordinal number by order of creation. Would be nice but I'll work around it. Thanks for the reply.
>
>Bill
>
>>Hi, Bill,
>>
>>There may be a better way, but the only way I know to do it for multiple table results is the following, after you get the result set back from SQL into a dataset...
>>
>>

>>MyDataResults.Tables[0].TableName = "myTableOfCustomers";
>>MyDataResults.Tables[1].TableName = "myTableOfProducts";
>>

>>
>>If there's a better way to do this, I'd be interested to learn as well!
>>
>>Kevin