locked
ConstraintException in MemberDetails RRS feed

  • Question

  • User473025879 posted

    I have done some modification of the Member Details, as well as the DataSet and database tables to go along with it.  I can create the user through the Member Registration page, but when I click on the Membership link to go to the more detailed profile, I get a System.Data.ConstraintException on this line in Member Details:

     
    DataSet.MemberInfoDataTable dt = da.GetMember((Guid)user.ProviderUserKey);
     

    The exception says

    System.Data.ConstraintException was unhandled by user code

      Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

     

    The troubleshooting tips were:

    Relax or turn off constraints in your DataSet (not sure how to do this)

    Clear datasets before loading them from view state (again, not sure how to do this)

    Be sure you are not trying to assign a value to a primary key field whose primary key already exists (I don't think I am)

     

    Anyone else run into this problem?  Any advice?

     

    Thanks,

     

    Jeff
     

    Tuesday, September 26, 2006 2:30 PM

All replies

  • User473025879 posted
    Found my own answer - there was a Select command at the bottom of the DataSet.xsd file that I hadn't updated with my additional member info.
    Thursday, September 28, 2006 9:01 AM
  • User-768222909 posted

    ok, so what specifically did you find and what did you do?  I am receiving the same error and don't know how to fix it

    Thursday, July 5, 2007 9:56 PM