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)"

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"  wrote in message 
news:%23ndHXms3HHA.5184@TK2MSFTNGP02.phx.gbl...

> 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)"
> 

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



"Lit"  wrote in message 
news:extydGt3HHA.5980@TK2MSFTNGP04.phx.gbl...

> 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"  wrote in message 
> news:%23ndHXms3HHA.5184@TK2MSFTNGP02.phx.gbl...
>> 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)"
>>
>
> 

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

"dancer"  wrote in message 
news:Ogv9Esz3HHA.5360@TK2MSFTNGP03.phx.gbl...

>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
>
>
>
> "Lit"  wrote in message 
> news:extydGt3HHA.5980@TK2MSFTNGP04.phx.gbl...
>> 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"  wrote in message 
>> news:%23ndHXms3HHA.5184@TK2MSFTNGP02.phx.gbl...
>>> 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)"
>>>
>>
>>
>
>