装载合框从表coulmn名称，只是数字

Question 1

我有一个表，其中列名数目只。现在我需要popuate一个组合框从该表根据所选择的价值的另一comcbo盒名为"cboStandard"，但它是trigerring错误 "的孩子的列表2场不能是创建". 注：表中列名决定的价值在所选择的组合框cboStandard 下面是我的代码来填充的框:

**Dim Series As String = (cboStandard.Text).Substring((cboStandard.Text).IndexOf(" ") + 1, 3)
        If Not Series.Contains("Sys") Then
            Dim getWeights As String = "Select [" & Series & "] from StandardChicken where [" & Series & "] > 0 "
            loadcombo(getWeights, cboStandardWeights, Series)
            Dim dt As New DataTable()
            dt = ret.LoadDataTable2(getWeights)
            If Not (dt.Rows.Count = 0) Then
                cboStandardWeights.DataSource = dt
                cboStandardWeights.DisplayMember = Series
                cboStandardWeights.ValueMember = Series
                cboStandardWeights.AutoCompleteSource = AutoCompleteSource.ListItems

            ElseIf dt.Rows.Count = 0 Then
                cboStandardWeights.Text = ""
                cboStandardWeights.DataSource = dt
                cboStandardWeights.ValueMember = Series
                cboStandardWeights.DisplayMember = Series
                cboStandardWeights.AutoCompleteSource = AutoCompleteSource.ListItems
            End If**

Question 2

做到以下几点：

private sub comboBox1_EditvalueChanged(sender As Object, e As EventArgs) Handles comboBox1.EditValueChanged
  dim myValue = CInt(comboBox1.EditValue)
  if myValue = 1 then
    'populate comboBox2
  else if myValue = 2
    'populate comboBox2 with other stuff
  end if
end sub

要容易得多。你可以做任何你想要的里面，你甚至可以隐藏和显示的第二组合框

Lorenzo Martini · Answer 1 · 2021-11-22T11:32:48

做到以下几点：

private sub comboBox1_EditvalueChanged(sender As Object, e As EventArgs) Handles comboBox1.EditValueChanged
  dim myValue = CInt(comboBox1.EditValue)
  if myValue = 1 then
    'populate comboBox2
  else if myValue = 2
    'populate comboBox2 with other stuff
  end if
end sub

要容易得多。你可以做任何你想要的里面，你甚至可以隐藏和显示的第二组合框

装载合框从表coulmn名称，只是数字

的问题

最好的答案

其他语言

此页面有其他语言版本

受欢迎的此类别

流行的问题，在这个类别