VS2005 Strongly Typed DS and Mutliple Result Set

[Jay Pondy]

Using a Stored Procedure that returns mutliple result sets how do I
populate a strongly typed dataset?

I've tried using a command object to call the SP and then using the
DataAdapters TableMappings collection as follows:

oAdp.TableMappings.Add("Table", DS.Junk.TableName)
oAdp.TableMappings.Add("Table1", DS.Stuff.TableName)

but I keep getting a "Failed to enable constraints. One or more rows
contains values violating non-null, unique or foreign-key constraints"
error.

 

[Jay Pondy]

My mistake there was a field missing from one of the queries that was
in the strongly typed dataset.