Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    27

    Unanswered: "Failed to enable constraints. One or more rows contain values violating non-null, un

    "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: m_dataAdapter.Fill(m_dsCarTrade,"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
    			m_accessConnection = new OleDbConnection(m_conStrAccessConnection);
    			m_accessCommand = new OleDbCommand(m_conStrSelectCommandCustomer, m_accessConnection);
    			m_dataAdapter = new OleDbDataAdapter(m_accessCommand);
    
    			//we open the connection to DB
    			m_accessConnection.Open();
    
    			try
    			{
    				m_dataAdapter.Fill(m_dsCarTrade,"CustomerAddress");
    
    				m_dataAdapter.Fill(m_dsCarTrade,"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();
    			}
    
    			m_dtCustomers = m_dsCarTrade.Tables["Customer"];
    		}
    Know someone why this error caused?

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    check the rulles on the table u are working with. looks like the primary key rulles have been vilated. you are insterting null information into a filed that can not accecpt nulls due to the configuration of the table
    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •