使用过滤器时维护DataGridView复选框状态

Question

有一个DataGridView，我通过My​​SQL查询填充了

Using command As New MySqlCommand("SELECT p_code as 'Prodcut Code', p_name as 'Product Name', filter " & _
                                      "from ordering_prc where isRetail = 0", conn)
        Using da As New MySqlDataAdapter(command)

            Dim dgvColumnHeaderStyle As New DataGridViewCellStyle() 'To center the headertext of the datagridview
            dgvColumnHeaderStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
            dtgridorder.ColumnHeadersDefaultCellStyle = dgvColumnHeaderStyle

            da.Fill(dt)

PROD	代码prod code	prod	coodbox
rockbox	row1	我	a
checkbox	row2 row2 b2	b row2	b

include the inception header用于复选框列。通过编程添加“复选框”列，

            Dim CheckBox As New DataGridViewCheckBoxColumn
            CheckBox.Width = "20"
            CheckBox.Name = "CheckBox"
            CheckBox.HeaderText = " "
            'CheckBox.ReadOnly = True
            dtgridorder.Columns.Insert(0, CheckBox)

这很好。我将能够使用复选框填充我的datagrid，但无法实现我尝试做的事情 - 检查复选框时要维护复选框的检查状态。 因此，我搜索并找到 this

Dim dt As New DataTable
Dim source1 As New BindingSource()
Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    Dim str As String = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\C# and VB Support\Example(VB)\Sample\Data1.mdf;Integrated Security=True"
    Dim sql As String = "select 0 as IsSelect,id,column1,column2 from test10"
    Dim con As New SqlConnection(str)
    Using cmd As New SqlCommand(sql, con)
        con.Open()
        Using Adapter As New SqlDataAdapter(cmd)
            Adapter.Fill(dt)
        End Using
        con.Close()
    End Using
    Dim view1 As New DataView(dt)
    source1.DataSource = view1
    DataGridView1.DataSource = view1
    DataGridView1.Refresh()

End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    source1.Filter = "Column1 like '%" & TextBox1.Text & "%'"

End Sub

我尝试使用此方法，但与编程添加的复选框相处不佳。当我遵循选择0作为ISSELECT，ID，column1，column2 from test10并将列直接添加到我的datagridview时，结果看起来像是此

Isselect	prod code code code	prod name	filt filter
0	row1 a	row1 a row1	a row2
a	row22	ROW2	B

如果我编辑0到1，则在我过滤datagrid时保持1个值，但不应该这样。复选框应出现。

有什么建议吗？