关于DevExpress的GridView的过滤条件如何转成相应的语句,dev官网提供了相应的处理方法,方便开发人员调用,目前支持数据库语句有MS Sql 、Oracle 、Access,
以下代码是相应的文本框的赋值
memoEdit4.Text = gridView1.ActiveFilterString;
memoEdit3.Text = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetAccessWhere(gridView1.ActiveFilterCriteria);
memoEdit2.Text = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetOracleWhere(gridView1.ActiveFilterCriteria,true);
memoEdit1.Text = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetMsSqlWhere(gridView1.ActiveFilterCriteria, true);
memoEdit5.Text = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDynamicLinqWhere(gridView1.ActiveFilterCriteria);
memoEdit6.Text = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDataSetWhere(gridView1.ActiveFilterCriteria);