Just giving you a hard time. Yes I know exactly what you mean, I sometimes have to code it for myself to believe it.

>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: "Table0, 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.