How to refresh a TableAdapter when changes are done to the DB/Stored Procedure
Posted on 2011-02-28
I've create a DAL using a dataset/tableadapter. The TableAdapter uses a Stored Procedure for the initial SELECT statement. I've had to make changes to this Stored Procedure and modify some of the columns that were returned.
Now when I attempt to run my code I get an error of...
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
The only way to fix the problem is to delted the TableAdaptor and recreate it. This can't be the solution. There must be a better way or, at least, I hope there is.
Is there a way to "refresh" the TableAdaptor when you make changes to your DB/Stored Procedure?