mysql - 在组合框中选择或显示某些行 mysql vb.net

Question

我有一个名为services的表，其中存储了所有正畸服务。以下是 services 表中存储的数据列表:

Extract
Cleaning
Jacket
Upper teeth braces
lower teeth braces
upper and lower teeth braces

我希望将这些服务存储/填充在 cmbBraces 中。但是，它会显示所有服务:我只希望在 cmbBraces 中填充三个特定服务(上牙套、下牙套、上下 dentry 矫正器)。

这是我填充 cmbBraces 的代码:

 MySqlConn.Open()
        Dim ds6 As New DataSet
        Dim da6 As New MySqlDataAdapter
        Dim dt6 As New DataTable
        Dim cmd10 As New MySqlCommand

        With cmd10
            .Connection = MySqlConn
            .CommandText = "SELECT Service_Name FROM services"
        End With
        da6.SelectCommand = cmd10
        dt6.Clear()
        da6.Fill(ds6)
        Dim dt1 As DataTable = New DataTable
        dt6 = ds6.Tables(0)


        For Each dtRow As DataRow In dt6.Rows
            cmbBracess.Items.Add(dtRow(0))
        Next
        MySqlConn.close()

Answer 1

满足您的要求的最简单、最正确的方法是向服务表中添加另一列。假设将此列称为位类型的 IsBrace(它只能有两个值 0 或 1)

现在您应该为每个 Services_Name 设置此列的以下值

 Service_Name                             IsBrace
 --------------------------------------------------------------
 Extract                                  0
 Cleaning                                 0
 Jacket                                   0
 Upper teeth braces                       1
 lower teeth braces                       1
 upper and lower teeth braces             1

完成此操作后，您可以更改查询以仅检索 IsBrace 列设置为 1 的行

 .CommandText = "SELECT Service_Name FROM services WHERE IsBrace = 1"