判断datagirdview中复选框是否选中

最新推荐文章于 2022-02-02 14:05:02 发布

crx05

最新推荐文章于 2022-02-02 14:05:02 发布

阅读量862

点赞数

文章标签： string exception cmd null

本文链接：https://blog.csdn.net/crx05/article/details/5158202

版权

for (int i = 0; i < dgvAccreditation.Rows.Count - 1; i++)
{
string No = this.dgvAccreditation.Rows[i].Cells["No"].Value.ToString();

                if (dgvAccreditation.Rows[i].Cells[1].Value != null) //判断该行的复选框是否存在
                {
                    if (dgvAccreditation.Rows[i].Cells[1].Value.ToString() == "True") //判断该复选框是否被选中
                    {

                        SqlConnection cn = db.GetConnection();
                        try
                        {
                            cn.Open();
                            string str1 = "update BoxAccreditation set IsPass='1' where No='" + No + "'";
                            SqlCommand cmd1 = db.GetCommand(str1, cn);

cmd1.ExecuteNonQuery();
cn.Close();

                        }
                        catch (Exception ex)
                        {

throw ex;
}

                    }
                    else
                    {
                        SqlConnection cnNo = db.GetConnection();
                        cnNo.Open();
                        string strNo = "update BoxAccreditation set IsPass='0' where No='" + No + "'";
                        SqlCommand cmdNo = db.GetCommand(strNo, cnNo);
                        cmdNo.ExecuteNonQuery();
                        cnNo.Close();
                    }

}
}