请各位给一个多条件查询的好算法好吗。。

[liangivw]

例如：

条件1 textbox1
条件2 textbox2
条件3 textbox3

按查询时可以按各个条件查，他们可以独立查询也可以组合查询，比如，按条件1查询时查出条件1的数据，如此类推，如果按条件1,2,3组合查询时可以查出符合三个条件的数据，还有时它们可能会有为空的时候，
除了用多重判断之外还可以有什么算法可以比较好啊，因为多重判断很类锁，而且容易出错。

[vbman2003]

dim sql as string ="select * from tb where 1=1 "
dim s1 as string = ""
dim s2 as string = ""
dim s3 as string = ""

if not (textbox1.text="") then s1 = " and fld1 ='"& textbox1.text &"'"
if not (textbox2.text="") then s1 = " and fld2 ='"& textbox2.text &"'"
if not (textbox3.text="") then s1 = " and fld3 ='"& textbox3.text &"'"

sql = sql & s1 & s2 & s3

是不是这个？

[vbman2003]

上面错了

dim sql as string ="select * from tb where 1=1 "
dim s1 as string = ""
dim s2 as string = ""
dim s3 as string = ""

if not (textbox1.text="") then s1 = " and fld1 ='"& textbox1.text &"'"
if not (textbox2.text="") then s2 = " and fld2 ='"& textbox2.text &"'"
if not (textbox3.text="") then s3 = " and fld3 ='"& textbox3.text &"'"

sql = sql & s1 & s2 & s3

[yunxiao_2004]

string strSQL ="select * from tb where 1=1 "

if (textbox1.text.Trim()!="")
strSQL += string.format(" and fld1 ='{0}'", textbox1.text);
if (textbox2.text.Trim()!="")
strSQL += string.format(" and fld2 ='{0}'", textbox2.text);
if (textbox3.text.Trim()!="")
strSQL += string.format(" and fld3 ='{0}'", textbox3.text);
何必还要什么 s1, s2 ,s3 干什么呢!!

[liangivw]

谢谢各位帮忙，我先试试