ds.Tables[0].DefaultView.RowFilter 日期过滤

Question

if (this.dateEditBdate.EditValue != null && this.dateEditEdate.EditValue != null)
                {
                    filter += " and CreateDatetime>='" + this.dateEditBdate.EditValue.ToString() + "' and CreateDatetime<='"+this.dateEditEdate.EditValue.ToString().SubString(0,10)+" 24:59:59'";
                    ds.Tables[0].DefaultView.RowFilter = filter;
                    ds.Tables[0].DefaultView.Sort = "CreateDatetime";
                }报错:无法在 System.DateTime 和 System.String 上执行“<=”操作。不知道该怎么写，请高手指教

Answer 1

'"+this.dateEditEdate.EditValue.ToString().SubString(0,10)+" 24:59:59'
两边的''去掉试试

Answer 2

string filter = "1=1 ";
                if (this.dateEditBdate.EditValue != null && this.dateEditEdate.EditValue != null)
                {
                    string btime = DateTime.Parse(this.dateEditBdate.EditValue.ToString()).ToString("yyyy-MM-dd HH:mm:ss").Substring(0, 10) + " 00:00:00";
                    string etime = DateTime.Parse(this.dateEditEdate.EditValue.ToString()).ToString("yyyy-MM-dd HH:mm:ss").Substring(0, 10) + " 23:59:59";
                    filter += " and CreateDatetime>='" + btime + "'" + " and CreateDatetime<='" + etime + "'";                    ds.Tables[0].DefaultView.RowFilter = filter;
                    ds.Tables[0].DefaultView.Sort = "CreateDatetime";
                }