string condition = "";
if (TextBox2.Text != "")
condition = condition + " sname like'" + TextBox2.Text + "%'";
if (DropDownList1.SelectedItem.ToString() != "")
condition = condition + "and sex='" + DropDownList1.SelectedItem + "'";
if (TextBox1.Text != "")
condition = condition + "and sno='" + TextBox1.Text + "'";
if (TextBox3.Text != "" && TextBox4.Text != "")
condition = condition + "and age>='" + TextBox3.Text + "'and age<='" + TextBox3.Text + "'"; Response.Write(condition);
string sql = "select * from s where" + condition;
Response.Write(sql);
这个是四个条件的组合查询,要怎么加代码才能让三个条件查询和四个条件查询并存??
SQL
if (TextBox2.Text != "")
condition = condition + " sname like'" + TextBox2.Text + "%'";
if (DropDownList1.SelectedItem.ToString() != "")
condition = condition + "and sex='" + DropDownList1.SelectedItem + "'";
if (TextBox1.Text != "")
condition = condition + "and sno='" + TextBox1.Text + "'";
if (TextBox3.Text != "" && TextBox4.Text != "")
condition = condition + "and age>='" + TextBox3.Text + "'and age<='" + TextBox3.Text + "'"; Response.Write(condition);
string sql = "select * from s where" + condition;
Response.Write(sql);
这个是四个条件的组合查询,要怎么加代码才能让三个条件查询和四个条件查询并存??
SQL
解决方案 »
- Datalist分页
- 请问为什么要在项目中添加引用 System.Configuration
- 关于 Print2Flash 生成swf
- 后台判断datagird选中某行的问题
- 如何保持Password文本框状态
- 关于sqldatareader的问题,帮忙给解答一下
- 【求助WMI问题】重启本地计算机,提示“没有保留特权”。
- 不用本机的邮件服务器发送邮件时(localhost没有邮件服务器时)
- 那个有csdn的这个BBS的全部源代码啊~~
- 救命!在vb.net中,用odbc连接oracle数据库出错
- 一般处理程序如何区分method
- 加了KindEditor后不能设置textArea readonly
string sql = "select * from s where 第四个条件 or (" + condition + ")";
using System.Text;StringBuilder sb = new StringBuilder();
if (TextBox1.Text != "")
{
sb.Append(" and sno='" + TextBox1.Text + "' ");
}
if(TextBox2.Text != "")
{
sb.Append(" sname like '" + TextBox2.Text + "%' ");
}
if(DropDownList1.SelectedItem.ToString() != "")
{
sb.Append(" and sex='" + DropDownList1.SelectedItem.Text + "' ");
}
if(TextBox3.Text != "")
{
sb.Append(" and age>='" + TextBox3.Text + "' ");
}
if(TextBox4.Text != "")
{
sb.Append(" and age<='" + TextBox4.Text + "' ");
}
Response.Write(sb.ToString());
string sql = "select * from s where 1=1 " + sb.ToString();
Response.Write(sql);
StringBuilder sb = new StringBuilder();
if (TextBox1.Text != "")
{
sb.Append(" and sno='" + TextBox1.Text + "' ");
}
if(TextBox2.Text != "")
{
sb.Append(" and sname like '" + TextBox2.Text + "%' ");
}
if(DropDownList1.SelectedItem.ToString() != "")
{
sb.Append(" and sex='" + DropDownList1.SelectedItem.Text + "' ");
}
if(TextBox3.Text != "")
{
sb.Append(" and age>='" + TextBox3.Text + "' ");
}
if(TextBox4.Text != "")
{
sb.Append(" and age<='" + TextBox4.Text + "' ");
}
Response.Write(sb.ToString());
string sql = "select * from s where 1=1 " + sb.ToString();
Response.Write(sql);
http://www.cnblogs.com/insus/archive/2011/03/30/1999795.htmlsee also:
http://www.cnblogs.com/insus/archive/2013/04/06/3002054.html