带空变量的字符串

Question

嘿，我正在做一个字符串，但是有些变量将是空的，我希望跳过这些变量，但不知道如何实现。下面是下面字符串的代码。

Dim TenantList As String = Ten11 & "," & Ten10 & "," & Ten9 & "," & Ten8 & "," & Ten7 & "," & Ten6 & "," & Ten5 & "," & Ten4 & "," & Ten3 & "," & Ten2 & "," & Ten1

Answer 1

您可以将它们放在集合中并使用String.Join。

Dim allStrings As String() = {Ten11, Ten12, Ten13, Ten14, ...}
Dim notEmpty = From str In allStrings Where Not String.IsNullOrEmpty(str)
Dim TenantList As String = String.Join(",", notEmpty)

我使用LINQ过滤空字符串，所以您需要Imports System.Linq。