Delete Command Syntax? [RESOLVED]
I want to edit my delete command by replacing the ? with a textbox value ...txtStudentID
With m_cmDelete
.Connection = m_cnStateUBookstore
.CommandType = CommandType.Text
.CommandText = "DELETE FROM Students WHERE StudentID = ?"
End With
I have tried numerous configurations to no avail. any ideas?
Re: Delete Command Syntax?
Did you try:
.CommandText = "DELETE FROM Students WHERE StudentID = " & txtStudentID.Text
Re: Delete Command Syntax?
Thanks, it took it. :thumb: