Monday, July 2, 2007

DataSet hell - Failed to enable constraints. One or more rows contain values...

I have found some great posts regarding
Typed DataSet regular problem that is faced by every programmer who starts working with datasets in good application.

http://weblogs.asp.net/rosherove/archive/2004/10/03/237260.aspx

What did I face?
Usually, as in most applications fields returns by every stored procedure even that's written on a gived table, are different.
So, result set of every stored procedure doesn't match the one specified in DataTable of Typed DataSet schema.

So, it's a good idea to setup individual table adapter for almost all procedures!!

No comments:

 
Dotster Domain Registration Special Offer