111,129
社区成员
发帖
与我相关
我的任务
分享
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);
}
}
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);
}
}