如果commandtext中的内容太长，如何实现换行？

[goldbrighten]

如下在vb.net 的vb程序中应该怎么换行写啊！
strUpdateStmt = "UPDATE table SET contactno = @txt(1) , name= @txt(2) , sex= @txt(3) where school=@txt(4),province =@txt(5),city=@txt(6) where [1]=@text1 and [2]=@text2 and [3]=@text3 and [4]=@text4 and [5]=@text5 and [6]=@text6"

[贝贝壳壳]

用＆连起来吧。

[timmy3310]

strUpdateStmt = "UPDATE table SET contactno = @txt(1) , name= @txt(2) , sex=txt"_
&"(3) where school=@txt(4),province =@txt(5),city=@txt(6) where [1]=@text1 and "_
&"[2]=@text2 and [3]=@text3 and [4]=@text4 and [5]=@text5 and [6]=@text6"

[goldbrighten]

两位大哥啊，你们试过没有啊，回报错的啦！

[lzliming]

应该是用_，_前面应该有空格吧？