the parameter names are not very good as i was just testing. it works so thanks for that.
I am using databinding but the sql command for add,update,delete
this is how a book i have teaches it.