how to update,delete from asp.net?

[Oracle Friend]

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:

[Pete OHanlon]

Best way to do this is through parameterized queries. See this[^] article for advice. Obviously, you will want to use the Oracle .Net providers.

Deja View - the feeling that you've seen this post before.

[rohitsrivastava]

imports system.data.sqlclient dim objsqlconn as sqlconnection dim objsqlcmd as sqlcommand dim dataset as dataset dim strupdate as string first update objsqlconn=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlconn.open strupdate="update EMP set f_name=:txt_name where id=:txt_id" objsqlcmd=new sqlcommand(strupdate,objsqlconn) objsqlcmd.executenonquery() messagebox.show("Record successfully update") second delete objsqlconn=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlconn.open strdelete="delete from EMP where id=:txt_id" objsqlcmd=new sqlcommand(strdelete,objsqlconn) objsqlcmd.executenonquery() messagebox.show("Record successfully delete")

[Oracle Friend]

: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

[Pete OHanlon]

How do you think this will work? First of all, you are connecting to SQL Server here, secondly the strupdate command is wrong. Finally, always use parameterized queries as they are much better.

Deja View - the feeling that you've seen this post before.