VS2005, dataSets and stored procs (how annoying!)

[Andy B]

Hi...

I have a dataset with queries in them. I want to switch out the queries for
stored procs. When I tried to redefine the select query as a stored proc, I
get this error:

Cannot remove unique constraint 'Constraint1'. Remove foreign key constraint
'fk_NewsHeader_NewsArticles' first.

Any idea what the problem is and how to fix it? The other problem is when
this does work, it redefines a new tableAdaptor in the name of the stored
proc... how confusing...

 

[sloan]

The LoadDataSet command can help you.

http://msdn.microsoft.com/msdnmag/issues/05/08/DataPoints/#S8


You'll have alot less headaches if you use the EnterpriseLibrary.Data
application block.