info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



How to parse a string in a VB.NET DataTable & add Hyperlink
by BF (Principal Consultant; Architecture; Engineering)
2015-06-28






Solution:

Dim Labels As String = resTabBlog.Rows(i).Item("Labels")
'Original string from db; comma-separated delimiter

Dim LabelsNew As String() = Nothing
LabelsNew = Labels.Split(",")

For ii As Integer = 0 To LabelsNew.Length - 1
If LabelsNew(ii) <> "" Then
LabelsNew(ii) = "<a href=/tag.aspx?TName=" & LabelsNew(ii) & ">" & LabelsNew(ii) & "</a>"
End If
Next

Dim result As String = String.Join(", ", LabelsNew)
'New string with hyperlink added

resTabBlog.Rows(i).Item("Labels") = result.ToString()
'Add new string back to DATATABLE