Row not found

Question

Hi,

I get the error Row not found or changed, when I try to update the database.
so far I've tried the following without succes:
- changed property Update check of all columns to "never"
- the refresh option adm1n.Refresh(RefreshMode.KeepCurrentValues, beheer3);

Here's the code

protected void Button13_Click(object sender, EventArgs e)
    {
FacturatieDataContext adm1n = new FacturatieDataContext();
    Beheren beheer3 = new Beheren();
Beheren beheer2 = new Beheren();
//select the row
var b3h3er1 = from c in adm1n.Beherens
                      where c.Naambeheer == TextBox1.Text
                      select c;

            //Make a new beheren item
            beheer3.Naambeheer = TextBox4.Text;
            //the old beheren item
            beheer2.Naambeheer = TextBox1.Text;
            //submit the changes
adm1n.Beherens.Attach(beheer3,beheer2);
        adm1n.SubmitChanges();
    }
Does anyone know how to solve this issue?
Thanx
Mike