IT Community - Software Programming, Web Development and Technical Support

Failed to enable constraints problem...

This is a discussion on Failed to enable constraints problem... within the C# Programming forums, part of the Software Development category; Hi I face this problem "Failed to enable constraints" when working with Adapter. Can anybody help me to ...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Software Development > C# Programming

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 12-27-2007, 04:51 AM
gp_logesh gp_logesh is offline
D-Web Trainee
 
Join Date: May 2007
Posts: 29
gp_logesh is on a distinguished road
Default Failed to enable constraints problem...

Hi

I face this problem "Failed to enable constraints" when working with Adapter.
Can anybody help me to solve this problem


Thanks in Advance
__________________
"GP_Logesh..."

Last edited by gp_logesh : 12-27-2007 at 04:56 AM. Reason: Misspelled
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-27-2007, 04:52 AM
SaravananJ SaravananJ is offline
D-Web Programmer
 
Join Date: Aug 2007
Posts: 79
SaravananJ is on a distinguished road
Default Re: Field to enable constrains problem...

If you get the following Error,
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Route cause for this problem was, some of the fields used in the Adapter violates the rules set in the table or the values (results) returned by the query\stored procedure violates the rule(constraint), So please check each field - columns in the Adapter control and the value passed to the Adapter
__________________
J.Saravanan
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 12-27-2007, 05:00 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 882
kingmaker is on a distinguished road
Send a message via Yahoo to kingmaker
Default Re: Failed to enable constraints problem...

Important thing :If u r using Table Adapter ..if the Column/Field allows null value...that will throws exception Data type other than the String/Varchar....u must take care of that columns...
__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TF30177: Team Project Creation Failed arjkhanna Server Management 2 01-31-2008 08:34 AM
What is data integrity? Explain constraints? sundarraja Database Support 1 01-18-2008 04:41 AM
Communication Made Easier - How to overcome Constraints? subbitss Technology BUZZzzzzz 0 08-07-2007 08:46 AM
Is it possible to enable the javascript in the Iframe Tag? bluesky HTML, CSS and Javascript Coding Techniques 0 07-16-2007 12:26 AM
diffrence between and constraints and triggers sivakumar Database Support 1 07-12-2007 04:00 AM


All times are GMT -7. The time now is 08:01 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0