DataSet DS_Drop = DbHelpSql.Run_select("select * from bumen");
this.DropDownList1.DataSource = DS_Drop;
this.DropDownList1.DataTextField = "bmName";
this.DropDownList1.DataValueField = "bumenID";
this.DropDownList1.DataBind();
this.DropDownList1.Items.Insert(0, "选择部门");
Label3.Text = DS_Drop.Tables[0].Rows[0]["bumenID"].ToString();
keshi(Label3.Text);
this.DropDownList2.Items.Insert(0, "选择科室");
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Label3.Text =DropDownList1.SelectedValue.ToString();
keshi(Label3.Text);
DropDownList1.Items.Remove("选择部门");
}
public void keshi(string str)
{
DropDownList2.Items.Clear();
int bumID = Convert.ToInt32(str);
DataSet DS_Drop1 = DbHelpSql.Run_select("select * from keshi where bumenID=" + bumID + "");
if (DS_Drop1.Tables[0].Rows.Count == 0)
{
DropDownList2.Items.Add("暂无科室");
DropDownList2.DataBind();
}
else
{
this.DropDownList2.DataSource = DS_Drop1;
this.DropDownList2.DataTextField = "ksName";
this.DropDownList2.DataValueField = "keshiID";
this.DropDownList2.DataBind();
}
}