首页 > 解决方案 > 组合框搜索表单加载事件的第一个索引项。我如何停止表单加载事件的搜索

问题描述

我根据combobox.combobox在表单加载事件上正确加载搜索名称,但它在表单加载事件上选择第一个项目,并且还根据第一个项目进行搜索。我如何在表单加载事件上停止此选择???

我使用 combobox1.selectedindex=-1。这在组合框中不显示任何项目,但根据组合框的第一项搜索...

   Private Sub Form1_Load(sender As Object, e As EventArgs) Handles 
    MyBase.Load
        Dim con As New SqlConnection
        con.ConnectionString = "data source=abc;initial 
        catalog=LoginDB;integrated security=true"
        cmd.Connection = con
        con.Open()
        cmd.CommandText = "search_data"
        cmd.CommandType = CommandType.StoredProcedure
        Dim dset As New DataSet
        Dim dpt As New SqlDataAdapter
        dpt.SelectCommand = cmd
        dpt.Fill(dset, "tab")
        ComboBox1.DataSource = dset.Tables("tab")
        ComboBox1.DisplayMember = "ID"
        ComboBox1.SelectedIndex = -1
    End Sub

    Private Sub ComboBox1_SelectedIndexChanged(sender As Object, e As 
    EventArgs) Handles ComboBox1.SelectedIndexChanged
        cmd.CommandText = "show_date"
        cmd.CommandType = CommandType.StoredProcedure

        p = New SqlParameter
        p.ParameterName = "@id"
        p.Value = ComboBox1.Text
        cmd.Parameters.Add(p)

        Dim dset As New DataSet
        Dim dpt As New SqlDataAdapter
        dpt.SelectCommand = cmd
        dpt.Fill(dset, "tab")
        If dset.Tables("tab").Rows.Count > 0 Then
        nameTextBox.Text = dset.Tables("tab").Rows(0)("name")
        End If
    End Sub

我希望当表单加载时没有搜索,当用户更改项目然后搜索...

标签: vb.net

解决方案


推荐阅读