Problem with update and delete statements

[masktoon]

hi ,

I am having a problem around here. I am using an OLEDB connection. I want to update the database with the new value.

I want to take user entry through a control and update the database value.

overall , please help me out and give the syntax for use of parameterized queries for Update & Delete Statements.

 

[mzim]

 'cn is a connection
 'update statement
 dim cm as new oledbcommand("update table set name='" & textbox1.text & "'",cn)
 cm.executenonquery
 'delete statement
 dim cm as new oledbcommand("delete from table where name='" & textbox1.text & "'",cn)
 cm.executenonquery