如何对GRIDVIEW内容进行筛选？

Question

如题，我打算通过一个文本框和两个下拉列表框中的数据对gridview的数据进行筛选
可是我的代码运行后却没反应，谁能看看哪有错了？    protected void btncha_Click(object sender, EventArgs e)
    {
        string source = "server=(local);integrated security=SSPI;database=cxsys";
        SqlConnection conn=new SqlConnection(source);
        SqlCommand cmd = conn.CreateCommand();
        SqlCommand cmd1=new SqlCommand();
        SqlCommand cmd2=new SqlCommand();
        string name, baobiao, jishui;
        name = this.txtleibiename.Text.ToString();
        baobiao = this.combbaobiao.Text.ToString();
        jishui = this.combjishui.Text.ToString();
        cmd.CommandText = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where xmlbname='" +
                          name + "')";
        cmd1.CommandText="SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where orbaobiao='" +
                          baobiao + "')";
        cmd2.CommandText="SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where orjishui='" +
                          jishui + "')";
        try
        {
            conn.Open();
            if(this.txtleibiename!=null)
            {
                SqlDataReader reader = cmd.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                this.SqlDataSource1.DataBind();
                reader.Close();
            }
            else if(this.combbaobiao.Text!=null)
            {
                SqlDataReader reader = cmd1.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                reader.Close();
            }
            else if(this.combjishui.Text!=null)
            {
                SqlDataReader reader = cmd2.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                reader.Close();
            }
        }
        catch (Exception ex)
        {
              Response.Write("<script>window.alert('错误！"+ex.Message.ToString()+"')</script>");
            
        }
        finally
        {
            conn.Close();
        }    }谢谢了

Answer 1

SqlCommand cmd1=new SqlCommand();
SqlCommand cmd2=new SqlCommand();
if(this.txtleibiename!=null)
以上三行有问题

Answer 2

combbaobiao.Text==""
而不是
combbaobiao.Text==null

Answer 3

听了楼上的建议，改了几处，可是还是有错protected void btncha_Click(object sender, EventArgs e)
    {
        string name, baobiao, jishui;
        name = this.txtleibiename.Text.ToString();
        baobiao = this.combbaobiao.Text.ToString();
        jishui = this.combjishui.Text.ToString();
        
        string source = "server=(local);integrated security=SSPI;database=cxsys";
        string nm = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where xmlbname='" +
                          name + "')";
        string bb = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where orbaobiao='" +
                          baobiao + "')";
        string js = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx where orjishui='" +
                          jishui + "')";
        SqlConnection conn=new SqlConnection(source);
        SqlCommand cmd = new SqlCommand(nm,conn);
        SqlCommand cmd1=new SqlCommand(bb,conn);
        SqlCommand cmd2=new SqlCommand(js,conn);        try
        {
            conn.Open();
            if(this.txtleibiename.Text!=null)
            {
                SqlDataReader reader = cmd.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                this.SqlDataSource1.DataBind();
                reader.Close();
            }
            else if(this.combbaobiao.Text!="")
            {
                SqlDataReader reader = cmd1.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                reader.Close();
            }
            else if(this.combjishui.Text!="")
            {
                SqlDataReader reader = cmd2.ExecuteReader();
                this.GridView1.DataSource = reader;
                this.GridView1.DataBind();
                reader.Close();
            }
        }
        catch (Exception ex)
        {
              Response.Write("<script>window.alert('错误！"+ex.Message.ToString()+"')</script>");
            
        }
        finally
        {
            conn.Close();
        }    }

Answer 4

可能是前台页面你没设置好吧，把文本框和2个下拉列表框绑定到gridview..

Answer 5

SqlDataReader是一种只读，需要游标向前读取记录的数据读取器。。还需要保持连接啥的不如使用
SqlConnection con=new SqlConnection("server=....");
SqlDataAdapter adapter=new SqlDataAdapter("select * from...",con);
DataSet ds=new DataSet();
adapter.Fill(ds,"表名");
GridView1.DataSource=ds;
GridView1.DataBind();

Answer 6

看了楼上的方法，自己有百度了一下
不知道这个方法是否可行，现在问题是报错
“GridView1”上同时定义了 DataSource 和 DataSourceID。请移除一个定义。
部分代码如下：string name, baobiao, jishui;
        name = this.txtleibiename.Text.ToString();
        baobiao = this.combbaobiao.SelectedValue.ToString();
        jishui = this.combjishui.SelectedValue.ToString();       
                try
        {
            if(this.txtleibiename.Text!=null)
            {
                
                string txtconn = "server=(local);integrated security=SSPI;database=cxsys";
                SqlConnection conn = new SqlConnection(txtconn);
                string txtcommand = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx";
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(txtcommand, conn);
                da.Fill(ds, "cwxzflx");
                GridView1.DataSource = ds;
                GridView1.DataMember = "cwxzflx";
                DataView dw = new DataView(ds.Tables["cwxzflx"]);
                dw.RowFilter = "xmlbname='" + name + "'";
                GridView1.DataSource = dw;            }
            else if(this.combbaobiao.Text!="")
            {
                
                string txtconn = "server=(local);integrated security=SSPI;database=cxsys";
                SqlConnection conn = new SqlConnection(txtconn);
                string txtcommand = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx";
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(txtcommand, conn);
                da.Fill(ds, "cwxzflx");
                GridView1.DataSource = ds;
                GridView1.DataMember = "cwxzflx";
                DataView dw = new DataView(ds.Tables["cwxzflx"]);
                dw.RowFilter = "orbaobiao='" + baobiao + "'";
                GridView1.DataSource = dw;
            }
            else if(this.combjishui.Text!="")
            {
                
                string txtconn = "server=(local);integrated security=SSPI;database=cxsys";
                SqlConnection conn = new SqlConnection(txtconn);
                string txtcommand = "SELECT xmlbname, orbaobiao, orjishui FROM cwxzflx";
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter(txtcommand, conn);
                da.Fill(ds, "cwxzflx");
                GridView1.DataSource = ds;
                GridView1.DataMember = "cwxzflx";
                DataView dw = new DataView(ds.Tables["cwxzflx"]);
                dw.RowFilter = "orjishui='" + jishui + "'";
                GridView1.DataSource = dw;
            }
        }
        catch (Exception ex)
        {
              Response.Write("<script>window.alert('错误！"+ex.Message.ToString()+"')</script>");
            
        }

Answer 7

你看看前台 aspx 页面，GridView1 那一段页面 代码 的 DataSourceID 绑定 sqldatasource 或者什么什么其他的 删掉，如无意外就可以了