SQL Delete command ExecuteNonQuery

[Martijn van Dru]

Does anybody know what the syntax is from a delete command when you use for example a value of a textbox (it's a DELETE command for an ExecuteNonQuery command)

I tried the following:

 

 

Dim squery As String = " DELETE FROM Table1 WHERE (ID = '" & textbox1.Text & "')"

 

I hope someone can help

 

Martijn

[Derek Stone]

Dim sQuery As String = "DELETE FROM [Table1] WHERE [Table1].[iD] = '" & TextBox1.Text.Replace("'", "''") & "'"

... should work just fine assuming that the field "ID" was defined in the table as a string or character value.

[Lenin82]

Dim Squery As String = "Delete FROM Table1 WHERE ID=" & txtBox.Text 

 

Thats what works for me, I was trying ID = 'ID NUMBER' but never got it working had to the remove both ' for it to work properly. Am using office 2000 dont know if that has anything to do with it

[Robby]

If the ID field is of numeric type then ....

 

Dim Squery As String = "Delete FROM Table1 WHERE ID=" & convert.toint32(txtBox.Text)

[Martijn van Dru]

Thanks, I tried it with

 

 

 

Dim sQuery As String = "DELETE FROM Table1 WHERE ID = "&
txtBox.Text

 

And it works for strings and integers

 

Goodbye, Martijn

[abi_sara2001]

Dim squery As String = " DELETE FROM Table1 WHERE ID = '" & textbox1.Text & "'"

 

 

This should work. Try this.

 

all the best.