CheckBoxList与表的操作

绑定控件：

  private void BindRevenueAreas()
    {
        cblAreas.Items.Clear();

        string _conStr = SysConfig.ConStr;
        OdbcConnection _odbcCon = new OdbcConnection(_conStr);
        _odbcCon.Open();

        string _sqlstr = "SELECT ID,RORA_ID FROM retail_outlet_revenuearea  where Deleted=0 order by RORA_Sequence asc";
        OdbcDataAdapter odbc = new OdbcDataAdapter(_sqlstr, _odbcCon);
        DataTable dt = new DataTable();
        odbc.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string ID = Convert.ToString(dt.Rows[i]["ID"]);
                string RORA_ID = Convert.ToString(dt.Rows[i]["RORA_ID"]);
                cblAreas.Items.Add(new ListItem(RORA_ID, ID));
            }
        }
        dt.Clear();

        _odbcCon.Close();
    }
保存：
 string strareas = "";
            for (int i = 0; i < cblAreas.Items.Count; i++)
            {
                if (cblAreas.Items[i].Selected == true)
                {
                    strareas += cblAreas.Items[i].Value.ToString() + "%";
                }
            }
            strareas = strareas.Substring(0, strareas.Length - 1);
            sqlStr += "Revenue_AreaID = '" + strareas + "' ";
取值：
 string strAreas = _list[24].ToString();
                    string[] strArr = strAreas.Split('%');
                    if (strAreas != "")
                    {
                        for (int i = 0; i < cblAreas.Items.Count; i++)
                        {
                            string cblcontent = cblAreas.Items[i].Value;
                            for (int j = 0; j < strArr.Length; j++)
                            {
                                string strcontent=strArr[j].ToString();
                                if (cblcontent ==strcontent )
                                {
                                    cblAreas.Items[i].Selected = true;
                                }
                            }
                        }
                    }