mysql - 如何在 item() 函数中插入来自 Mysql 命令的连接字符串

Question

这是我的代码

 Select Case activebarangay
        Case "Barangay Barangka"
            DataGridView1.DataSource = Exec("Select * from barangka_logbook")

            reader = ExecReader("Select family_number from barangka_patient_infomation")

            If reader.HasRows Then

                While reader.Read
                    familynumberComboBox.Items.Add(reader.Item("family_number"))
                End While
            End If

            'Member name
            reader = ExecReader("Select concat(first_name,' ',middle_name,' ',last_name) from barangka_patient_infomation WHERE family_number = '" & familynumberComboBox.Text & "' ")

            If reader.HasRows Then

                While reader.Read
                    membernameComboBox.Items.Add(reader.Item("concat(first_name,' ',middle_name,' ',last_name)"))
                End While
            End If

这就是我所说的是否可以在 Item() 函数中放入一个连接的字符串:

 If reader.HasRows Then
     While reader.Read
         membernameComboBox.Items.Add(reader.Item("concat(first_name,' ',middle_name,' ',last_name)"))
     End While

怎么可能呢？请帮我 结束如果

Answer 1

在选择列表中使用 as 关键字提供字段别名，并使用别名来引用连接字段:

       ...
       reader = ExecReader("Select concat(first_name,' ',middle_name,' ',last_name) as full_name from barangka_patient_infomation WHERE family_number = '" & familynumberComboBox.Text & "' ")

        If reader.HasRows Then

            While reader.Read
                familynumberComboBox.Items.Add(reader.Item("full_name"))
            End While
        End If