//设置combox的值--------------
private void setCombo(string sql, CheckedComboBox cmb)
{
//清空下拉列表
cmb.Items.Clear();
//cmb.Items.Add("%");
//cmb.Text = "%";
//实例化一个类
getLxerpConn v = new getLxerpConn();
//获取类里面的sql连接到数据库的字符串
v.getsqlconn();
// string connStr = "Data Source=.\\sql2008;Initial Catalog=books;Integrated Security=True"; //连接到数据库的字符串
SqlConnection cn = new SqlConnection(v.Sqlconn);
//打开链接
cn.Open();
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = sql;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmb.Items.Add(dr.GetValue(0).ToString().Trim());
}
cn.Close();
cn.Dispose();
}
private CheckedComboBox Add_CheckedComboBox(CheckedComboBox ccb, Control above_crl, string sql, string lableText)
{
ccb = new CheckedComboBox();
setCombo(sql, ccb);
ccb.Top = above_crl.Top + above_crl.Height + 13;
ccb.Left = above_crl.Left;
groupPanel2.Controls.Add(ccb);
Label l = new Label();
l.Text = lableText;
l.Top = above_crl.Top + above_crl.Height + 16;
l.Left = label1.Left;
l.BackColor = Color.Transparent;
groupPanel2.Controls.Add(l);
return ccb;
}
// ********************************************* Construction *********************************************
public Dropdown(CheckedComboBox ccbParent)
{
this.ccbParent = ccbParent;
InitializeComponent();
this.ShowInTaskbar = false;
// Add a handler to notify our parent of ItemCheck events.
this.cclb.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.cclb_ItemCheck);
}