:rose:Thanks rohitsrivastava this is very Advance code ,but at the moment am using access database .I want only the Syntax or the command to delete,update. I remmber in the past I was writing like this but am not soure about the Syntax updatecode="update EMP set f_name Val&"(first_name.txt)"&''&"where id=Val&"(txtid.txt)"&" -- modified at 8:07 Wednesday 12th September, 2007 yasser

any one remind me how to update,delete on asp.net based on given txtfield? e.g we write code like this in oracle: --update code: update EMP set f_name=:txt_name where id=:txt_id; commit; ---delete code: delete from EMP where id=:txt_id; commit; yesser yasser :rose:

any one remind me how to update,delete on asp.net based on given txtfield? e.g we write code like this in oracle: --update code: update EMP set f_name=:txt_name where id=:txt_id; commit; ---delete code: delete from EMP where id=:txt_id; commit; yesser