string cmdText="select * from table where 1=1 ";if(txtUserName.Text!="") { cmdText +=" and UserName like '%"+ txtUserName.Text +"%' "; }if(txtAddress.Text!="") { cmdText +=" and Address like '%"+ txtAddress.Text +"%' "; }//数据库查询
StringBuilder 在效率上要高于String. using System.Text;... StringBuilder sb = new StringBuilder(); sb.Append("select * from table where 1=1 )";if(txtUserName.Text!="") { sb.Append(" and UserName like '%"+ txtUserName.Text +"%')"; } if(txtAddress.Text!="") { sb.Append(" and Address like '%"+ txtAddress.Text +"%')"; } string strSQL = sb.ToString();//数据库查询
用神马都成,最重要的是实现功能.
{
cmdText +=" and UserName like '%"+ txtUserName.Text +"%' ";
}if(txtAddress.Text!="")
{
cmdText +=" and Address like '%"+ txtAddress.Text +"%' ";
}//数据库查询
using System.Text;...
StringBuilder sb = new StringBuilder();
sb.Append("select * from table where 1=1 )";if(txtUserName.Text!="")
{
sb.Append(" and UserName like '%"+ txtUserName.Text +"%')";
}
if(txtAddress.Text!="")
{
sb.Append(" and Address like '%"+ txtAddress.Text +"%')";
}
string strSQL = sb.ToString();//数据库查询