小弟现在写个多条件选择查询的页面,现在功能都已经实现,但是查询一次后再查询的话就因为参数(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)
{ }
现在想每次查询后将页面刷新,参数重构,那位大哥给个思路,要用到哪些函数?或者有哪些更好的法子,谢谢大家了!
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)
{ }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货