我做了一个DropDownList联动(给出部门,显示出其下的员工名字),但是我不管怎么绑定都不显示其下名字,不知道代码哪里出了问题,请高手帮忙!!!
protected void qxbm()
{
SqlConnection con1 = DataCon.getCon();
con1.Open(); SqlCommand cmd1 = new SqlCommand("select * from department", con1); SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataSet bm = new DataSet();
da.Fill(bm); qxbumen.DataSource = bm;
qxbumen.DataTextField = "dept_department";
qxbumen.DataValueField = "dept_id";
qxbumen.DataBind();
con1.Close(); } protected void qxdx()
{ SqlConnection con2 = DataCon.getCon();
con2.Open(); SqlCommand cmd2 = new SqlCommand("select u_username from users where u_dept_id='" + qxbumen.SelectedValue + "'", con2); SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = cmd2; DataSet dx = new DataSet();
da2.Fill(dx); qxduixiang.DataSource = dx;
qxduixiang.DataTextField = "u_username";
qxduixiang.DataValueField = "u_id";
qxduixiang.DataBind();
con2.Close();
}
protected void qxbm()
{
SqlConnection con1 = DataCon.getCon();
con1.Open(); SqlCommand cmd1 = new SqlCommand("select * from department", con1); SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataSet bm = new DataSet();
da.Fill(bm); qxbumen.DataSource = bm;
qxbumen.DataTextField = "dept_department";
qxbumen.DataValueField = "dept_id";
qxbumen.DataBind();
con1.Close(); } protected void qxdx()
{ SqlConnection con2 = DataCon.getCon();
con2.Open(); SqlCommand cmd2 = new SqlCommand("select u_username from users where u_dept_id='" + qxbumen.SelectedValue + "'", con2); SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = cmd2; DataSet dx = new DataSet();
da2.Fill(dx); qxduixiang.DataSource = dx;
qxduixiang.DataTextField = "u_username";
qxduixiang.DataValueField = "u_id";
qxduixiang.DataBind();
con2.Close();
}
{
if (!IsPostBack)
qxbm();
} protected qxbumen_SelectedIndexChanged(object sender, System.EventArgs e)
{
qxdx();
}
{
qxdx();
}
谢谢楼上,qxdx();这个没加的关系!
但是如果是三级联动,在显示员工名字的同时还显示该员工的权限那要怎么改,如果只是再加上面这样的语句还是不能实现。
protected void qxxz()
{
SqlConnection con3 = DataCon.getCon();
con3.Open(); SqlCommand cmd3 = new SqlCommand("select * from popedom where pop_id=(select u_pop_id from users where u_dept_id= (select dept_id from department where dept_department='" + qxbumen.SelectedValue + "'))", con3); SqlDataAdapter da3 = new SqlDataAdapter();
da3.SelectCommand = cmd3; DataSet xz = new DataSet();
da3.Fill(xz); qxxuanze.DataSource = xz;
qxxuanze.DataTextField = "pop_popedom";
qxxuanze.DataValueField = "pop_id";
qxxuanze.DataBind();
con3.Close();
}
这个select语句有错误吗?