小弟现在写个多条件选择查询的页面,现在功能都已经实现,但是查询一次后再查询的话就因为参数(paramIP,paramCus)重复创建而报错!
  现在想每次查询后将页面刷新,参数重构,那位大哥给个思路,要用到哪些函数?或者有哪些更好的法子,谢谢大家了!
  SqlData1.ConnectionString = WebConfigurationManager.ConnectionStrings["SZIDCConnectionString"].ConnectionString;
            String sql = "SELECT * FROM tb_Server WHERE 1=1   ";
            if (IsPostBack)
            {
                if (CheckBox1.Checked)
                {                    ControlParameter SelIP = new ControlParameter("paramIP", "txtIP", "text");
                    SqlData1.SelectParameters.Add(SelIP); 
                    sql = sql + "and (ServerIP =  @paramIP )";
                    Response.Write(sql + 1);                }
                if (CheckBox2.Checked)
                {
                    ControlParameter SelCus = new ControlParameter("paramCus", "txtCus", "Text");
                    SqlData1.SelectParameters.Add(SelCus);
                    sql = sql + "and(CusID = @paramCus)";
                    Response.Write(sql + 2);
                }
            }
            Response.Write(sql+3);
            SqlData1.SelectCommand = sql;
    }
    protected void btn1_Click(object sender, EventArgs e)
    {    }