Long Line to list

[dancer]

Using ASP.net1.1 and Parameters

I have many more fields to put into this statement.
How can I list them vertically instead of one long line?


Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident,
TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor,
ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays,
@TheSNN, @TheJob, @TheSupervisor, @ThePart)"

 

[Lit]

use the underscore character ( _ ) to split line?

Dim MySql AS String = "INSERT INTO Table1(TheEmpName,TheDateOfAccident, _

TheBirth, TheLostDays, TheSSN, TheJob, TheSupervisor, _

ThePart)VALUES(@TheEmpName, @TheDateOfAccident, @TheBirth, @TheLostDays, _

@TheSNN, @TheJob, @TheSupervisor, @ThePart)"
is that what you want?

Lit

 

[dancer]

I had tried that. I also tried using & _. I also tried putting & at the
beginning of the next line. But I always get this error:
String constants must end with a double quote

 

[dancer]

Never mind. I realized I have to use vbCrLf _
Thanks.