VS2005 Strongly Typed DS and Mutliple Result Set

  • Thread starter Thread starter Jay Pondy
  • Start date Start date
J

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.
 
My mistake there was a field missing from one of the queries that was
in the strongly typed dataset.
 
Back
Top