Monday, December 28, 2009

ASP.NET Error

After ages I am doing a Technical post on my blog. I usually put them here for future reference because when we fix a problem and face the problem again its easy to refer back else you have to think again, how had I fixed it last time, what was wrong. To save time this post.

I got the Famous Yellow page with message:
"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

I was reading data from my Typed Dataset and I knew there was no such constraints that would fail in the result set. SO before I started thinking Complex, I thought there has to be something simple. As I knew my Data sources. The problem was caused by a discrepancy between the defined max size of a data column in my Typed Dataset and the size returned from the database. Simple wasn't it.

1 comment:

Anonymous said...

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!