使用文本框过滤记录时保持复选框的状态 [英] Maintaining state of checkboxes while filtering record using textbox

问题描述

我正在开发一个 C# windows 应用程序，以将记录从 SQL Server 填充到数据网格视图，每行都有动态复选框功能.我想通过该特定行的复选框出于某种目的选择选定的行.到目前为止，我已成功实现目标，但我在保存已检查状态方面遇到了一个小问题.

I am working on a C# windows application to populate records from SQL Server to data grid view, with dynamic checkbox facility in each row. I want to select selected rows for some purpose via checkbox of that particular row. Till now I successfully achieve my target, but I'm facing a minor issue regarding saving a checked status.

例如，我只想检查 Name = Max 的那些记录.我在那个文本框中有一个文本框，我用 Query 调用文本更改事件:

For example I want to check only those records whose Name = Max. I have a textbox in that textbox I call text change event with like Query:

 try
    {
        SqlCommand cmd = null;
        SqlConnection con = null; Ranks rank = new Ranks();
        con = new SqlConnection(cs.DBcon);
        con.Open();
        cmd = con.CreateCommand();
        cmd.CommandText = "Select * from Records where Name like @Name order by Pno";
        cmd.Parameters.AddWithValue("@Name", "%" + FilterByNameTextbox.Text.Trim() + "%");
        SqlDataAdapter adapter1 = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        adapter1.Fill(dt);

        dataGridView1.DataSource = dt;
        Make_fields_Colorful();
    }
    catch (Exception exception)
    {
        MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);
    }

如果我在按名称过滤器文本框中写入 Max，它将返回 3 个名称以 max 开头的记录，使用类似查询，就像我上面提到的代码一样.所以我只使用动态复选框检查 3 条记录中的 2 条，直到现在我的代码运行完美.现在我想检查名称以 Ali 开头的记录，现在当我在过滤器中按名称文本框写入 ali 时，它将返回名称类似于 ali 的行，但问题出现在这里它将删除我以前检查过的记录，所以我将如何保存 max 和 ali 行的检查记录:

If I write Max in filter by name textbox it would return 3 records with name starts with max using like query as I mention code above. So I only check 2 records out of 3 using dynamic checkbox, till now my code runs perfectly. Now I want to check records which name starts from Ali, now when I write ali in my filter by name textbox it will return rows where name like ali , but problem comes here it will remove my previous checked records, so how I would able to save checked records for both max and ali's rows:

每行添加动态复选框的代码

Code for adding dynamic checkboxes in each row

DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
    checkBoxColumn.Name = "checkBoxColumn";
    checkBoxColumn.DataPropertyName = "Report";
    checkBoxColumn.HeaderText = "Report";
    dataGridView1.Columns.Insert(10, checkBoxColumn);
    dataGridView1.RowTemplate.Height = 100;
    dataGridView1.Columns[10].Width = 50;

图像:

图片 1

图片 2

推荐答案

我建议你通过缓存选定的行来实现这一点，首先你应该有一个缓存行的列表:

I suggest you achieve this by caching selected rows, first you should have a list of cached rows:

List<DataGridViewRow> CachedRows = new List<DataGridViewRow>();

然后在单元格值更改时添加事件处理程序，如下所示:

then add event handler on cell value change like the following:

dataGridView1.CellValueChanged += view_CellValueChanged;

并且处理程序应检查更改的列是否为复选框并已选中，应如下所示:

and the handler should check if the column changed is the checkbox and checked, should be something like the following:

try
{
    if(e.ColumnIndex == indexOfCheckBoxColumn)
    {
       if((bool)dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == true)
       {
        CachedRows.Add((DataGridViewRow)dataGridView1.Rows[e.RowIndex].Clone());
       }
       else if (CachedRows.Contains(dataGridView1.Rows[e.RowIndex]))//Validate if this works, if not you should associate each row with unique key like for example (id) using a dictionary
       {
          CachedRows.Remove(dataGridView1.Rows[e.RowIndex]);
       }
    }
}
catch(Exception ex)
{
}

然后过滤器更改后，再次重新添加缓存的行，因此代码变为:

then after the filter changes, re-add the cached rows again, so code becomes:

try
    {
        SqlCommand cmd = null;
        SqlConnection con = null; Ranks rank = new Ranks();
        con = new SqlConnection(cs.DBcon);
        con.Open();
        cmd = con.CreateCommand();
        cmd.CommandText = "Select * from Records where Name like @Name order by Pno";
        cmd.Parameters.AddWithValue("@Name", "%" + FilterByNameTextbox.Text.Trim() + "%");
        SqlDataAdapter adapter1 = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        adapter1.Fill(dt);

        dataGridView1.DataSource = dt;
        //add folowing
        if (CachedRows.Any())
        {
            dataGridView1.Rows.AddRange(CachedRows.ToArray());
            CachedRows.Clear();
        }
        Make_fields_Colorful();
    }
    catch (Exception exception)
    {
        MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);
    }

这篇关于使用文本框过滤记录时保持复选框的状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！