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/is...DataPoints/#S8
You'll have alot less headaches if you use the EnterpriseLibrary.Data
application block.

"Andy B" <a_*****@sbcglobal.netwrote in message
news:e0**************@TK2MSFTNGP06.phx.gbl...

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...