我需要打破这一行代码,但我不知道如何:
sql = "select [ID], [First Name], [Last Name], [Mark 1 ENG], [Mark 2 ENG], [Mark 3 ENG], [Mark 1 MAT], [Mark 2 MAT], [Mark 3 MAT], [Mark 1 SCI], [Mark 2 SCI], [Mark 3 SCI] from Table1 where [Active] <> 'No'"
这就是我说休息时的意思:
If txtFirstName.Text = "" Or txtLastName.Text = "" Or txtMarks(0).Text = "" Or txtMarks(1).Text = "" Or txtMarks(2).Text = "" _
Or txtMarks(3).Text = "" Or txtMarks(4).Text = "" Or txtMarks(5).Text = "" Or txtMarks(6).Text = "" Or txtMarks(7).Text = "" _
Or txtMarks(8).Text = "" Then
我将下划线放在哪一行,因为无论我将它们放在哪里都给我一个错误。
您必须通过串联拆分字符串:
sql = "select [ID], [First Name], [Last Name], [Mark 1 ENG], [Mark 2 ENG], " & _
"[Mark 3 ENG], [Mark 1 MAT], [Mark 2 MAT], [Mark 3 MAT], [Mark 1 SCI], " & _
"[Mark 2 SCI], [Mark 3 SCI] from Table1 where [Active] <> 'No'"
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句