How to update the record with sql update

[Kivanc]

rs("Yazaradi") = txtYa.Text
rs("Kitapadi") = txtEa.Text
rs("Yayinevi") = txtYe.Text
rs("ISBN") = txtIsbn.Text
rs.Update
As I use this code to update, it updates the record but leaves the old record behind. Actually it doesn't work properly.

Ok, I would like to know how to use the sql update in the code above to update the record properly. Could somebody give an example?

Thank you