dropdownlist作为条件进行搜索
有两个dropdownlist(ddljizhong.ddlla),我已经实现了对他们的联动.
现在有一个BUTTON按钮,点击按钮,通过ddlla这个下拉框的作为条件.搜索数据库.
帮我看看代码.出问题了.
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//绑定机种
SqlConnection con = jizhong.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select * from jizhong", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddljizhong.DataSource = sdr;
this.ddljizhong.DataTextField = "jzName";
this.ddljizhong.DataValueField = "jzID";
this.ddljizhong.DataBind();
sdr.Close();
//绑定拉
SqlCommand cmdla=new SqlCommand("select * from la where
jzID='"+this.ddljizhong.SelectedValue+"'",con);
sdr = cmdla.ExecuteReader();
this.ddrla.DataSource = sdr;
this.ddrla.DataTextField = "laName";
this.ddrla.DataValueField = "laID";
this.ddrla.DataBind();
sdr.Close();
con.Close();
}
}
protected void ddljizhong_SelectedIndexChanged(object sender, EventArgs e)
{
string jzID = this.ddljizhong.SelectedValue;
SqlConnection con = jizhong.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select * from la where jzID='" + jzID + "'", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.ddrla.DataSource = sdr;
this.ddrla.DataTextField = "laName";
this.ddrla.DataValueField = "laID";
this.ddrla.DataBind();
sdr.Close();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = zong.createcon();
con.Open();
string cmdtxt3 = "select jz,la from bsperson where la='" +ddrla.SelectedValue+ "'
and jizhong='"+ddljizhong.SelectedValue+"'";
SqlDataAdapter da = new SqlDataAdapter(cmdtxt3, con);
DataSet ds = new DataSet();
da.Fill(ds,"bsperson");
this.GridView1.DataSource = ds.Tables["bsperson"].DefaultView;
this.GridView1.DataBind();
con.Close();
}