LOL ... I don't think that came out the way I meant it. <g> I didn't mean it to sound like "Well, if you don't believe me, then experiment yourself. Harumph!". What I really meant by that was that most often experimenting with simple things is the best way to learn stuff. And writing out the DataSet to an XML file is a pretty easy way to see what you're actually getting back from the Stored Proc.
Glad I could help. =)
~~Bonnie
>>>>A Stored Proc will always return your tables with the names: table, Table1, Table2, etc. Typically you are not going to want to reference the tables that way in your DataSet. There are two ways around this problem.
>>>
>>>Bonnie, thanks for the reply. Above you wrote: "table, Table1, Table2, etc." did you mean: "Table
0, Table1, Table2, etc." or did you acctually mean Table without a number?
>>
>>Table without a number. Experiment if you like ... retrieve a DataSet from a Stored Proc that has multiple tables, then write it out to an XML file and take a look at it. You'll see the table names.
>>
>>~~Bonnie
>
>Lol I belive you. I just simply assumed that the first table also had a number and I didn't get my SP to work with my dataset. After re-reading your message I tried using Table and it worked. Thanks Bonnie.