我把一个DropDownList进了了数据库绑定、但是在其他页面进行关于它的数据库查询操作时却无法执行,不报错,但是却直接在GridView里直接显示所有的数据。
这是数据绑定代码:
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=xianyulinbin;database=Caiwu");
SqlDataAdapter dap = new SqlDataAdapter("select * from Bank", conn);
DataTable dt = new DataTable();
dap.Fill(dt);
DropDownList1.Items.Clear();
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "BankName";
DropDownList1.DataValueField = "BankName";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("", ""));
这是下面的调用代码:
string sqlstr="select * from Jinzhang where 1=1 ";
if(ddlYear.SelectedValue !="")
{
sqlstr += " and Data like '"+ddlYear.SelectedValue+"%'";
}
if(ddlMonth.SelectedValue !="")
{
sqlstr += " and Data like '%-" + ddlMonth.SelectedValue + "-%'";
}
if(ddlDay.SelectedValue !="")
{
sqlstr += " and Data like '%-%-" + ddlDay.SelectedValue + "'";
}
if(DropDownList1.SelectedValue !="")
{
sqlstr += " and Bank ='" + DropDownList1.SelectedValue + "'";
}
前面3个if语句能正常的执行,就是最后一个if语句不行,希望能告知原因。
这是数据绑定代码:
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=xianyulinbin;database=Caiwu");
SqlDataAdapter dap = new SqlDataAdapter("select * from Bank", conn);
DataTable dt = new DataTable();
dap.Fill(dt);
DropDownList1.Items.Clear();
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "BankName";
DropDownList1.DataValueField = "BankName";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("", ""));
这是下面的调用代码:
string sqlstr="select * from Jinzhang where 1=1 ";
if(ddlYear.SelectedValue !="")
{
sqlstr += " and Data like '"+ddlYear.SelectedValue+"%'";
}
if(ddlMonth.SelectedValue !="")
{
sqlstr += " and Data like '%-" + ddlMonth.SelectedValue + "-%'";
}
if(ddlDay.SelectedValue !="")
{
sqlstr += " and Data like '%-%-" + ddlDay.SelectedValue + "'";
}
if(DropDownList1.SelectedValue !="")
{
sqlstr += " and Bank ='" + DropDownList1.SelectedValue + "'";
}
前面3个if语句能正常的执行,就是最后一个if语句不行,希望能告知原因。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货