时间的比较以及数据库中的时间范围搜索

if(Convert.ToDateTime(this.textbox1.text)>Convert.ToDateTime(this.textbox2.text))

{

condition+=" and TaskTime between convert(datetime, " +this.textbox1.text+“ , 102) and convert(datetime, " +this.textbox2.text+“ , 102)";

}