checkedListBox和combobox值传递出错

flytigerme 2010-10-12 10:00:22

有一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);

            }

             

        }