就是有个下拉框,如果都不输入的话,就显示下拉框项中得相应数据库,
我的想法是凑成("select * from STUDENT where Type='" + ddl1.SelectedItem.Text.ToString() + "'" and (name='XX' or age=XX))这样的,如果用StringBuilder来做,
StringBuilder sb = new StringBuilder();
sb.Append("select * from STUDENT where ProType='" + ddl1.SelectedItem.Text.ToString() + "'");
......
......
if (!string.IsNullOrEmpty(TextBox1.Text.Trim()))
{
sb.Append(" or " + DropDownList1.SelectedValue.ToString() + " like '%" + TextBox1.Text + "%'");这样来追加sb的话
那怎么判断是第一个,且把or去掉,
我的想法是凑成("select * from STUDENT where Type='" + ddl1.SelectedItem.Text.ToString() + "'" and (name='XX' or age=XX))这样的,如果用StringBuilder来做,
StringBuilder sb = new StringBuilder();
sb.Append("select * from STUDENT where ProType='" + ddl1.SelectedItem.Text.ToString() + "'");
......
......
if (!string.IsNullOrEmpty(TextBox1.Text.Trim()))
{
sb.Append(" or " + DropDownList1.SelectedValue.ToString() + " like '%" + TextBox1.Text + "%'");这样来追加sb的话
那怎么判断是第一个,且把or去掉,
这样就不用去掉第一个的or了,因为1=2返回都是false,只要后面的成立就可以