怎样进行复合性查询?也就是混合性查询(条件有长有短)?可能:
select * from qarpt where "+Session["time1"].ToString()+" = '"+Session["date61"].ToString()+"'
也可能:
select * from qarpt where "+Session["time1"].ToString()+" = '"+Session["date61"].ToString()+"' and pono='"+Session["pono"].ToString()+"'
我的理解是否可以把条件变成一个string s 来:
select * from qarpt where s ???
select * from qarpt where "+Session["time1"].ToString()+" = '"+Session["date61"].ToString()+"'
也可能:
select * from qarpt where "+Session["time1"].ToString()+" = '"+Session["date61"].ToString()+"' and pono='"+Session["pono"].ToString()+"'
我的理解是否可以把条件变成一个string s 来:
select * from qarpt where s ???
s2="1=1 and 2=2"
sql =s1+s2execute(sql)
s2= "1=1 and 2=2 "
sql =s1+s2
execute(sql)
s2= "1=1 and 2=2 "
sql =s1+s2
execute(sql)
.
.
.