时间戳

首页 > 解决方案 > 所有复选框的 CheckBox CheckedChanged 事件？

vb.net - 所有复选框的 CheckBox CheckedChanged 事件？

问题描述

是否可以将事件用于所有复选框？我有两个复选框，当我激活一个时，另一个被停用。它进入一个循环。当我尝试停用复选框时，将调用已停用复选框的 CheckedChanged 并生成循环错误

        Private Sub CheckBox1_CheckedChanged(sender As Object, e As EventArgs) Handles CheckBox1.CheckedChanged
    
        Dim da As MySqlDataAdapter
        Dim dt As DataTable
        If CheckBox1.Checked = True Then
            CheckBox2.CheckState = CheckState.Unchecked
            Openconnection()
            da = New MySqlDataAdapter("SELECT * FROM User WHERE " & Cbx_Filter.Text & " LIKE'" & Txt_Filter.Text & "%' and Stats = 'OK'", Connections)
        Else
            If CheckBox2.Checked = False Then
                Openconnection()
                da = New MySqlDataAdapter("SELECT * FROM User WHERE " & Cbx_Filter.Text & " LIKE'" & Txt_Filter.Text & "%'", Connections)
            End If
        End If
        dt = New DataTable
        da.Fill(dt)
        DataGridView1.Columns.Clear()
        DataGridView1.DataSource = dt
        Connections.Close()
        da.Dispose()

和复选框2

    Private Sub CheckBox2_CheckedChanged(sender As Object, e As EventArgs) Handles CheckBox2.CheckedChanged
        Dim da As MySqlDataAdapter
        Dim dt As DataTable
        If CheckBox2.Checked = True Then
            CheckBox1.CheckState = CheckState.Unchecked
            Openconnection()
            da = New MySqlDataAdapter("SELECT * FROM User WHERE " & Cbx_Filter.Text & " LIKE'" & Txt_Filter.Text & "%' and Stats = ''", Connections)
        Else
            If CheckBox1.Checked = False Then
                Openconnection()
                da = New MySqlDataAdapter("SELECT * FROM User WHERE " & Cbx_Filter.Text & " LIKE'" & Txt_Filter.Text & "%'", Connections)
            End If
        End If

        dt = New DataTable
        da.Fill(dt)
        DataGridView1.Columns.Clear()
        DataGridView1.DataSource = dt
        Connections.Close()
        da.Dispose()

End Sub

标签： vb.netloopscheckbox

解决方案

案例选项是：

1 - 没有人选择 2 - 1 选择 2

使用 RadioCheckBox 我无法在使用 CheckBoxes 选择后取消选中 Radio 我有一个循环问题（我需要取消选中另一个）

推荐阅读