Tutorial :Multiline strings in VB.NET



Question:

Is there a way to have multiline strings in VB.NET like Python

a = """  multi  line  string  """  

or PHP?

$a = <<<END  multi  line  string  END;  

Of course something that is not

"multi" & _  "line  


Solution:1

You can use XML Literals to achieve a similar effect:

Imports System.XML  Imports System.XML.Linq  Imports System.Core    Dim s As String = <a>Hello  World</a>.Value  

Remember that if you have special characters, you should use a CDATA block:

Dim s As String = <![CDATA[Hello  World & Space]]>.Value  

2015 UPDATE:

Multi-line string literals were introduced in Visual Basic 14 (in Visual Studio 2015). The above example can be now written as:

Dim s As String = "Hello  World & Space"  

MSDN article isn't updated yet (as of 2015-08-01), so check some answers below for details.

Details are added to the Roslyn New-Language-Features-in-VB-14 Github repository.


Solution:2

VB.Net has no such feature and it will not be coming in Visual Studio 2010. The feature that jirwin is refering is called implicit line continuation. It has to do with removing the _ from a multi-line statement or expression. This does remove the need to terminate a multiline string with _ but there is still no mult-line string literal in VB.

Example for multiline string

Visual Studio 2008

Dim x = "line1" & vbCrlf & _          "line2"  

Visual Studio 2010

Dim x = "line1" & vbCrlf &           "line2"  


Solution:3

I used this variant:

     Dim query As String = <![CDATA[          SELECT               a.QuestionID          FROM               CR_Answers a            INNER JOIN               CR_Class c ON c.ClassID = a.ClassID          INNER JOIN              CR_Questions q ON q.QuestionID = a.QuestionID          WHERE               a.CourseID = 1          AND               c.ActionPlan = 1          AND q.Q_Year = '11/12'          AND q.Q_Term <= (SELECT CurrentTerm FROM CR_Current_Term)      ]]>.Value()  

it allows < > in the string


Solution:4

Multiline string literals are introduced in Visual Basic 14.0 - https://roslyn.codeplex.com/discussions/571884

You can use then in the VS2015 Preview, out now - http://www.visualstudio.com/en-us/downloads/visual-studio-2015-downloads-vs (note that you can still use VS2015 even when targeting an older version of the .NET framework)

Dim multiline = "multi  line  string"  

VB strings are basically now the same as C# verbatim strings - they don't support backslash escape sequences like \n, and they do allow newlines within the string, and you escape the quote symbol with double-quotes ""


Solution:5

Multi-line strings are available since the Visual Studio 2015.

Dim sql As String = "      SELECT ID, Description      FROM inventory      ORDER BY DateAdded  "  

You can combine them with string interpolation to maximize usefullness:

Dim primaryKey As String = "ID"  Dim inventoryTable As String = "inventory"    Dim sql As String = $"      SELECT {primaryKey}, Description      FROM {inventoryTable}      ORDER BY DateAdded  "  

Note that interpolated strings begin with $ and you need to take care of ", { and } contained inside â€" convert them into "", {{ or }} respectively.

Here you can see actual syntax highlighting of interpolated parts of the above code example:

enter image description here

If you wonder if their recognition by the Visual Studio editor also works with refactoring (e.g. mass-renaming the variables), then you are right, code refactoring works with these. Not mentioning that they also support IntelliSense, reference counting or code analysis.


Solution:6

this was a really helpful article for me, but nobody mentioned how to concatenate in case you want to send some variables, which is what you need to do 99% of the time.

... <%= variable %> ...

Here's how you do it:

<SQL> SELECT * FROM MyTable WHERE FirstName='<%= EnteredName %>' </SQL>.Value


Solution:7

Well, since you seem to be up on your python, may I suggest that you copy your text into python, like:

 s="""this is gonna   last quite a   few lines"""  

then do a:

  for i in s.split('\n'):      print 'mySB.AppendLine("%s")' % i    #    mySB.AppendLine("this is gonna")  #    mySB.AppendLine("last quite a")  #    mySB.AppendLine("few lines")  

or

  print ' & _ \n'.join(map(lambda s: '"%s"' % s, s.split('\n')))    #    "this is gonna" & _   #    "last quite a" & _   #    "few lines"  

then at least you can copy that out and put it in your VB code. Bonus points if you bind a hotkey (fastest to get with:Autohotkey) to do this for for whatever is in your paste buffer. The same idea works well for a SQL formatter.


Solution:8

Multi-line string literals in vb.net using the XElement class.

Imports System.Xml.Linq    Public Sub Test()    dim sOderBy as string = ""    dim xe as XElement = <SQL>                  SELECT * FROM <%= sTableName %>                   <ORDER_BY> ORDER BY <%= sOrderBy %></ORDER_BY>                   </SQL>    '** conditionally remove a section   if sOrderBy.Length = 0 then xe.<ORDER BY>.Remove    '** convert XElement value to a string   dim sSQL as String = xe.Value    End Sub  


Solution:9

To me that is the most annoying thing about VB as a language. Seriously, i once wrote the string in a file and wrote code something along the lines of:

Dim s as String = file_get_contents("filename.txt")  

just so i could test the query directly on SQL server if i need to.

My current method is to use a stored procedure on the SQL Server and just call that so i can pass in parameters to the query, etc


Solution:10

I figured out how to use both <![CDATA[ along with <%= for variables, which allows you to code without worry.

You basically have to terminate the CDATA tags before the VB variable and then re-add it after so the CDATA does not capture the VB code. You need to wrap the entire code block in a tag because you will you have multiple CDATA blocks.

Dim script As String = <code><![CDATA[    <script type="text/javascript">      var URL = ']]><%= domain %><![CDATA[/mypage.html';    </script>]]>  </code>.value  


Solution:11

You could (should?) put the string in a resource-file (e.g. "My Project"/Resources) and then get it with

 Dim a = My.Resources.Whatever_you_chose  


Solution:12

Disclaimer: I love python. It's multi-line strings are only one reason.

But I also do VB.Net, so here's my short-cut for more readable long strings.

  Dim lines As String() = {      "Line 1",      "Line 2",      "Line 3"    }    Dim s As String = Join(lines, vbCrLf)  


Solution:13

you can use XML for this like

dim vrstr as string = <s>      some words      some words      some      words  </s>  


Solution:14

in Visual studio 2010 (VB NET)i try the following and works fine

Dim HtmlSample As String = <anything>what ever you want to type here with multiline strings</anything>    dim Test1 as string =<a>onother multiline example</a>  


Solution:15

Available in Visual Basic 14 as part of Visual Studio 2015 https://msdn.microsoft.com/en-us/magazine/dn890368.aspx

But not yet supported by R#. The good news is they will be supported soon! Please vote on Youtrack to notify JetBrains you need them also.


Solution:16

If you need an XML literal in VB.Net with an line code variable, this is how you would do it:

<Tag><%= New XCData(T.Property) %></Tag>  


Solution:17

Use vbCrLf or vbNewLine. It works with MessageBoxes and many other controls I tested.

Dim str As String  str = "First line" & vbCrLf & "Second line"  MsgBox(str)  str = "First line" & vbNewLine & "Second line"  MsgBox(str)  

It will show two identical MessageBoxes with 2 lines.


Solution:18

You can also use System.Text.StringBuilder class in this way:

Dim sValue As New System.Text.StringBuilder  sValue.AppendLine("1st Line")  sValue.AppendLine("2nd Line")  sValue.AppendLine("3rd Line")  

Then you get the multiline string using:

sValue.ToString()  


Solution:19

Since this is a readability issue, I have used the following code:

MySql = ""  MySql = MySql & "SELECT myTable.id"  MySql = MySql & " FROM myTable"  MySql = MySql & " WHERE myTable.id_equipment = " & lblId.Text  


Solution:20

No, VB.NET does not yet have such a feature. It will be available in the next iteration of VB (visual basic 10) however (link)


Solution:21

if it's like C# (I don't have VB.Net installed) you can prefix a string with @

foo = @"Multiline  String"  

this is also useful for things like @"C:\Windows\System32\" - it essentially turns off escaping and turns on multiline.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »