Articles

How to delete in VB.NET

June 30, 2006 at 11:40:11
Specs: WIN XP, 1.8 gig /512 DDR

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.


See More: How to delete in VB.NET

Report •


#1
July 3, 2006 at 01:39:15

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 "


Report •
Related Solutions


Ask Question