Hi Bill,
You can set the table names before you do the fill by using TableMappings. To get an example of how this is done, here is a link to an entry in my weblog:
http://blogs.prenia.com/cathi/PermaLink.aspx?guid=1b6e47c0-a58e-4e6f-bad7-ab11124820e6>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
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi