dropdownlist与gridview的关联

 

设置一个按钮，在CLICK事件下分别获取DROPDOWNLIST的TEXT的值，再根据这3个值用SQL语句进行查询！代码如下
protected void Button_Click(object sender, EventArgs e)
             {
                SqlConnection conn = new SqlConnection("Data Source=（local）;Initial Catalog=你的数据库名;Integrated Security=True");
                string str1 = this.DropDownList1.SelectedItem.Text;
                string str2 = this.DropDownList2.SelectedItem.Text;
string str3 = this.DropDownList3.SelectedItem.Text;
                       DataSet ds = new DataSet();
                       SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM table WHERE Column1 like '%" + str1 + "%'and Column2 like '%" + str2 + "%' and Column3 like '%" + str3 + "%'", conn);
                       da.Fill(ds, "你的表名");
                       GridView1.DataSource = ds;
                       GridView1.DataMember = "你的表名";
                       GridView1.DataBind();
                    }