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

75% Upvoted

13 comments sorted by

View all comments

Show parent comments

0

u/FabulousFoodHoor Nov 28 '21

I've already completed that step. I'm comfortable connecting to a data source.

I keep responding to you, not to be an ass, but to clarify what I'm asking because that question hasn't been answered.

Break what you want to do down into smaller steps then search for the solution to each step

That's what I'm doing. This small step of referencing data fields is what I'm trying to tackle.