有一checkedListBox和combobox,我在checkedListBox选中几项,将选中集合传递给combobox,但是提示将varchar值'李贞贤'转换为数据类型为Int的列时发生错误!初始化checkedlistbox private void Form2_Load(object sender, EventArgs e)
        {
            try
            {
                string str = "SELECT CollectNodeId,CollectNodeName FROM CollectPointProp";
                this.openSqlConnect();
                adapter = new SqlDataAdapter(str, this.con);
                builder = new SqlCommandBuilder(adapter);
                dataSet = new DataSet();
                adapter.Fill(dataSet, "CollectPointProp");                List<ListItem> itemsCol = new List<ListItem>();
                foreach (DataRow row in dataSet.Tables["CollectPointProp"].Rows)
                {
                    //itemsCol.Add(new ListItem(row["CollectNodeId"].ToString().Trim(), row["CollectNodeName"].ToString().Trim()));
                    ListItem li = new ListItem(row["CollectNodeId"].ToString().Trim(), row["CollectNodeName"].ToString().Trim());
                    checkedListBoxCollectPoint.Items.Add(li);
                }
                checkedListBoxCollectPoint.DataSource  = itemsCol;
                checkedListBoxCollectPoint.DisplayMember = "Text";
                checkedListBoxCollectPoint.ValueMember = "Value";                this.closeSqlConnect();
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
        }
将值传递给combobox
 private void button1_Click(object sender, EventArgs e)
        {            try
            {
                foreach (ListItem lt in checkedListBoxCollectPoint.SelectedItems)
                {                                     
                    f.listBoxSelected.Add(lt);
                }
                f.comboBoxSelectCollectPoint.DataSource =f.listBoxSelected;
                f.comboBoxSelectCollectPoint.DisplayMember = "Text";
                f.comboBoxSelectCollectPoint.ValueMember = "Value";                this.Close();
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
             
        }求高人指点!