Hello, How do you delete a row in vb.net where there is a blank data?
I've tried the following, and all do not work...
strSQL = DELETE FROM tblProducts WHERE prodID = & " "
strSQL = DELETE FROM tblProducts WHERE prodID = & Nothing
Thanks in advance.
You seem to be mixing vb.net syntax with SQL syntax, Try
strSQL = " DELETE FROM tblProducts WHERE prodID = '' "
and
strSQL = " DELETE FROM tblProducts WHERE prodID is null "