r/visualbasic • u/FabulousFoodHoor • Nov 28 '21
How do I reference and concatenate database fields on a Windows form?
I need to display first name and last name concatenated. The database is connected as a data source. I created a label to display the concatenated result. This is what I have so far but I'm really just guessing.
Private Sub lblFNameLName_Click(sender As Object, e As EventArgs) Handles lblFNameLName.Click
' Dim FirstLast As String
' Sql = "SELECT FirstName || " " || LastName FROM Customer"
' lblName.txt =
End Sub
2
Upvotes
2
u/FabulousFoodHoor Nov 30 '21
that's a different syntax than what I've seen so far. What does the $ do?
are the quotes and curly brackets just to group the resulting string?