"Failed to enable constraints. One or more rows co

• • Reply

  18 years ago

  by gicio

  gicio

  , United States

  Joined 18 years ago

  
  

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

  
  

  
  

  
  

  
  

  
  Hi!
  

  
  I get this error when I excetute this code
  

  
  (error on line: mdataAdapter.Fill(mdsCarTrade,"CustomerAddress")
  

  
  

  
  also I get one error in one Row:
  

  
  <error: an exception of type: {System.Data.StrongTypingException} occurred>
  

  
  (Tables have a relationship to eachother)
  

  
  

  
  [CODE]
  

  
         private OleDbDataAdapter m_dataAdapter;
  

  
         private OleDbConnection m_accessConnection;
  

  
         private OleDbCommand m_accessCommand;
  

  
  

  
         private    const string m_conStrAccessConnection  = "provider=Microsoft.JET.OLEDB.4.0; " +
                                                        "data source = C:\Visual Studio Projects\" +
                                                        "CarTrade\CarTradeDB.mdb";    
  

  
                 private const string m_conStrSelectCommandCustomer = "SELECT Customer., CustomerAddress. FROM Customer INNER JOIN CustomerAddress ON Customer.CustomerID = CustomerAddress.CustomerID";
  

  
  

  
         private void LoadFreshCustomersFromDB()
         {
             //we create an access object
             maccessConnection = new OleDbConnection(mconStrAccessConnection);
             maccessCommand = new OleDbCommand(mconStrSelectCommandCustomer, maccessConnection);
             mdataAdapter = new OleDbDataAdapter(m_accessCommand);
  

  
             //we open the connection to DB
             m_accessConnection.Open();
  

  
             try
             {
                 mdataAdapter.Fill(mdsCarTrade,"CustomerAddress");
  

  
                 mdataAdapter.Fill(mdsCarTrade,"Customer");
  

  
             }
             catch (Exception e)
             {
                 MessageBox.Show("Sorry....but we have some problems with database. " + "Error message from database : " + e.Message,"ERROR!!!");
  

  
             }
             finally
             {
                 //we close the connection to DB
                 m_accessConnection.Close();
             }
  

  
             mdtCustomers = mdsCarTrade.Tables["Customer"];
         }
  

  
  

  
  [/CODE]
  

  
  Know someone why this error caused?
  

  
  

  
  

  
  

  
  

  
  

  Report abuse