One of the "gotchas" with bringing down multiple tables with one SP, is that the table names are *always* table, Table1, Table2, etc. and I haven't found any way around that. So, you have to have your DataSet tables named appropriately. But, since we use typed DataSets, it's no big deal ... we can name our tables however we want to in the typed DataSet and thus have meaningful names to access our tables with.
As I said previously with the updates, we have the "roll-your-own" approach ... setting the SqlCommand to the SP, adding the Parameters (PK's usually) and doing a ExecuteNonQuery() seems to cover all the bases.
~~Bonnie
>Yep, it works for me. I kept running into problems before. IAC, what if you have multiple tables in the dataset? How do you handle that as well as updates right now???
>