Winform中给DataGridView添加多选框列并获取选中行的内容

忘是亡心i 2024-04-17 06:01 71阅读 0赞

## 场景 ##

使用NPOI导入Excel并赋值给DataTable,然后显示在DataGrdView上，并且添加多选框，然后获取选中行的内容。

Winform中使用NPOI实现Excel导入并赋值给DataTable：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/100064821][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100064821]

## 实现 ##

给DataGridView添加多选框，而不是给DataTable添加多选框。

DataGridViewColumn checkCol = new DataGridViewCheckBoxColumn();
    this.dataGridView1.Columns.Add(checkCol);

获取选中行的内容

private void button4_Click(object sender, EventArgs e)
            {
               
               
                int strCount = 0;
                //首先进行第一次循环 获取选中的行数
                for (int i = 0; i <dataGridView1.Rows.Count; i++)
                {
                    //如果被选中
                    if ((bool)dataGridView1.Rows[i].Cells[0].EditedFormattedValue == true)
                    {
                        strCount++;
                    }
                }
                //新建 选中长度的数组存放每一行
                string[] str = new string[strCount];
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    if ((bool)dataGridView1.Rows[i].Cells[0].EditedFormattedValue == true)
                    {
                        //获取当前行的第一个单元格 + @ +第二个单元格的内容
                        str[i] = dataGridView1.Rows[i].Cells[1].Value.ToString() + "@" + dataGridView1.Rows[i].Cells[2].Value.ToString();
                    }
                }
                //输出选中所有行的内容
                for (int i = 0; i < str.Length; i++)
                {
                    MessageBox.Show(string.Format("获取的第{0}条为：",i+1) +str[i]);
                }
               
            }

### 效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_100064821]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100064821
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/16/753f8632cfa4497e802ae95c6be44b17.jpg