GridView，DropDownList结合使用！

 SqlConnection con = new SqlConnection("server = ZMQHBD2007;uid = sa; pwd = 123;database = data");
    protected void Page_Load(object sender, EventArgs e)
    {
        con.Open();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlDataAdapter sda = new SqlDataAdapter("select * from category",con);
        DataSet ds = new DataSet();
        sda.Fill(ds,"category");
        GridView1.DataSource = ds.Tables["category"];
        GridView1.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strCond = " ";
        switch (DropDownList1.SelectedValue.ToString())
        {
            case "北京":
                strCond = "categorycity = '北京市'";
                break;
            case "南京":
                strCond = "categorycity = '南京市'";
                break;
            case "上海":
                strCond = "categorycity = '上海市'";
                break;
            case "杭州":
                strCond = "categorycity = '杭州市'";
                break;
        }
        string str = "select * from category where " + strCond;
        //SqlCommand cmd = new SqlCommand(str, con);
        //SqlDataReader sdr = cmd.ExecuteReader();
        //GridView1.DataSource = str;
        //GridView1.DataBind();
        //sdr.Close();
        SqlDataAdapter sda = new SqlDataAdapter(str, con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "category");
        GridView1.DataSource = ds.Tables["category"].DefaultView;
        GridView1.DataBind();
    }