¶àÌõ¼þ²éѯaccessÊý¾Ý¿â - .NET¼¼Êõ / ASP.NET

Ò³ÃæÓÐ5¸ödropdownlist£¨ddl1,ddl2,ddl3,ddl4,ddl5£©Ò»¸öTextBox (txt1)
ËûÃÇ¿ÉÒÔÈÎÒâ×éºÏÈ¥²éѯÊý¾Ý¿â
Èç¹ûÆäÖеÄĪһ¸öΪ¿ØÖÆÔò²»²ÎÓë²éѯÌõ¼þÖУ¬
Äܸø¸ö´úÂë×îºÃ£¬¸ø¸ö˼·Ҳ·Ç³£µÄ¸Ðл£¡

---

string sql=" select * from table where 1=1"

if(ddl1.selectValue!=""){
  sql+=" and ddl='"+ddl1.selectValue+"'"
}
if(ddl2.selectValue!=""){
  sql+=" and ddl='"+ddl2.selectValue+"'"
}

Èç´ËÕâ°ã

---

д¸öƴдsqlÓï¾äµÄº¯Êý
C# code:

string sqlStr = "select * from table1 where 1=1 "
if (param1.trim() £¡= "")
sqlStr += "and column1='" + param1.trim();
........



 

---

StringBuilder sb = new StringBuilder();
  sb.Append("select a.kh,a.name,b.fkfs,b.skje,b.czje,b.idate,b.czy from hyxx a,hycz b");
  sb.Append(" where a.id=b.hyid ");
  sb.Append(" and (a.kh=@kh or @kh is null)");
  sb.Append(" and (Convert(char(10),b.idate,120) >= @start or @start is null) ");
  sb.Append(" and(Convert(char(10),b.idate,120) <= @endTime or @endTime is null)");
  SqlParameter[] para = new SqlParameter[]