CheckBoxList获取选中项和绑定选中项

1、初始化CheckBoxList

BLL.gov_deptmanage bll = new BLL.gov_deptmanage();
cblItem.DataSource = bll.GetAllList();
cblItem.DataValueField = "ID";
cblItem.DataTextField = "Department";
cblItem.DataBind();

 

2、页面添加一个CheckBoxList，后台进行选中，关键代码如下：

public void BindChecked(int manageId)
        {
            BLL.gov_deptmanage bll = new BLL.gov_deptmanage();
            DataTable dt = bll.GetList(1, "manageId="+ manageId, "ID desc").Tables[0];
            if (dt.Rows.Count > 0)
            {
                string[] arr = dt.Rows[0]["deptId"].ToString().Trim().Split(',');
                foreach (ListItem lst in this.cblItem.Items)
                {                    
                    for (int i = 0; i < arr.Length; i++)
                    {
                        if (arr[i].ToString().Equals(lst.Value))
                            lst.Selected = true;
                    }
                }
            }
        }

 

3、保存选中值到数据库

protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string deptId = "";
            foreach (ListItem lst in this.cblItem.Items)
            {
                if (lst.Selected == true)
                {
                    deptId += lst.Value + ",";
                }
            }
            BLL.gov_deptmanage bll = new BLL.gov_deptmanage();
            Model.manager model = GetAdminInfo(); //取得管理员信息
            bll.Delete("manageId=" + model.id);

            Model.gov_deptmanage modelDeptManage = new Model.gov_deptmanage();
            modelDeptManage.manageId = model.id;
            modelDeptManage.deptId = deptId;
            if(bll.Add(modelDeptManage)>0)
            {
                JscriptMsg("保存成功！", "saveDept.aspx");
            }
        }