string sql = string.Format("update tb_Addressbook set Name = '" + Address_1.Text + "',Sex='" + Address_2.Text + "',Phone = '" + Address_3.Text + "',QQ='" + Address_4.Text + "',WordPhoe ='" + Address_5.Text + "',E_Mail='" + Address_6.Text + "',Handset='" + Address_7.Text + "' where ID =" + Store.Address_ID);
其中 Store.Address_ID静态字段,存放的是查询表中的ID所获得的值
SqlHelper.SqlExecuteNonQuery(sql, CommandType.Text);
其他信息: 违反了 PRIMARY KEY 约束“PK__tb_Addre__3214EC27A6EE7F9C”。不能在对象“dbo.tb_AddressBook”中插入重复键。重复键值为 (1)。