Dim cmd ,cmd1 As New SQLCommand
cmd.CommandText = "DELETE FROM {订单} WHERE 产品 = 'PD01'"
cmd.ExecuteNonQuery()
cmd1.CommandText = "DELETE FROM {订单} WHERE 产品 = 'PD02'"
cmd1.ExecuteNonQuery()
或:
Dim cmd As New SQLCommand
cmd.CommandText = "DELETE FROM {订单} WHERE 产品 = 'PD01'"
cmd.ExecuteNonQuery()
cmd = New SQLCommandcmd.CommandText = "DELETE FROM {订单} WHERE 产品 = 'PD02'"
cmd.ExecuteNonQuery()