Socarsky
Well-known member
I try to get multiple fields from DB as you can see the below in string line. But I can only get concanetated of name and surname.
I need to get the others in an list or array, but how?
I need to get the others in an list or array, but how?
Private Sub btnSelect_Click(sender As Object, e As EventArgs) Handles btnSelect.Click Dim mylist As New List(Of String) cs.Open() Dim PsqlQuery As String = "SELECT RTRIM(Name)+' '+Surname, email, city, telno from Contacts WHERE surname LIKE 'Bas%';" Dim readData As PsqlDataReader Dim adapt As New PsqlDataAdapter Dim cmd As New PsqlCommand cmd.CommandText = PsqlQuery cmd.Connection = cs adapt.SelectCommand = cmd readData = cmd.ExecuteReader While readData.Read() mylist.Add(readData(0).ToString) End While cs.Close() Dim str As String For Each str In mylist MessageBox.Show(str) Next End Sub