62,041
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string sqlconstr = ConfigurationManager.ConnectionStrings["ConnectionServer"].ConnectionString;
SqlConnection con = new SqlConnection(sqlconstr);
con.Open();
SqlCommand cmd = new SqlCommand("select * from branch", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddl1.Items.Add("未选择");
this.ddl1.DataSource = sdr;
this.ddl1.DataTextField = "name";
this.ddl1.DataValueField = "reviewmode";
this.ddl1.DataBind();
sdr.Close();
con.Close();
}
}
protected void ddl1_SelectedIndexChanged1(object sender, EventArgs e)
{
string sqlconstr = ConfigurationManager.ConnectionStrings["ConnectionServer"].ConnectionString;
SqlConnection con = new SqlConnection(sqlconstr);
con.Open();
SqlCommand cmd = new SqlCommand("select * from groupname where reviewmode=" + this.ddl1.SelectedValue + "", con);
SqlDataReader sdr = cmd.ExecuteReader();
ddl2.Items.Add("未选择");
this.ddl2.DataSource = sdr;
this.ddl2.DataTextField = "groupname";
this.ddl2.DataValueField = "grouptype";
this.ddl2.DataBind();
sdr.Close();
con.Close();
}
protected void ddl2_SelectedIndexChanged1(object sender, EventArgs e)
{
if (ddl2.SelectedValue == "2")
{
CheckBoxList1.Visible = true;
}
else {
CheckBoxList1.Visible = false;
}
}