有一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);
}
}求高人指点!
{
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);
}
}求高人指点!
解决方案 »
- 关于线程调用API函数的问题,没有反应,请指教!!!
- 怎么做可自动隐藏的面板?
- 怎样把DB2数据库中的表结构和数据导入SQL SERVER数据库中?(100分)
- C#调用dll,出现内存操作错误
- 谁知道onclick=UserDialog('InsertImage'); 语句的含义?
- wpf中对元素使用的动画,怎么删除了呢?
- groupBox 切换标签页时判断下是否能切换的问题
- 怎样把文本文件导入数据库?
- XML 文档中怎样放入特殊字符,例如0xA,后面没有0xD,不能直接放一个回车
- 请教c#调dll,参数是BYTE**,怎么处理?
- socket一点问题
- Java中的vector与c#中的哪个集合比较像呢?
看下这句获取的数据集中的内容是什么样的。