"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?