如何执行DefaultView.RowFilter进行AND操作？ [英] How To Perform DefaultView.RowFilter Having AND OR Operation?

问题描述

下面表达式的Plz回复语法：



studentDt.DefaultView.RowFilter =acyear_id ='+ ddl_academic_year.ControlValue +'AND applied_course_id ='+ ddl_grade.ControlValue +'AND emp_id ='+ ddl_subject_teacher.ControlValue +'AND fee_com_subgrp_id ='+ ddl_term.ControlValue +'AND（house_id ='+ ddl_house.ControlValue +OR house_id ='+ string。空+'）;



错误显示在线+'和（house_id ='+ ddl_house.ControlValue +或house_id ='+ string.Empty + '）;

Plz Reply Syntax For Below Expression:

studentDt.DefaultView.RowFilter ="acyear_id='"+ddl_academic_year.ControlValue + "'AND applied_course_id='" + ddl_grade.ControlValue + "'AND emp_id='" + ddl_subject_teacher.ControlValue + "'AND fee_com_subgrp_id='" + ddl_term.ControlValue +"'AND (house_id='" + ddl_house.ControlValue + " OR house_id ='"+string.Empty+"')";

Error Show On line +"'AND (house_id='" + ddl_house.ControlValue + " OR house_id ='"+string.Empty+"')";

推荐答案

// operator AND has precedence over OR operator, parenthesis are needed
dataView.RowFilter = "City = 'Tokyo' AND (Age < 20 OR Age > 60)";

// following examples do the same
dataView.RowFilter = "City <> 'Tokyo' AND City <> 'Paris'";
dataView.RowFilter = "NOT City = 'Tokyo' AND NOT City = 'Paris'";
dataView.RowFilter = "NOT (City = 'Tokyo' OR City = 'Paris')";
dataView.RowFilter = "City NOT IN ('Tokyo', 'Paris')";

这些是DataView.Rowfilter的基本示例

These are the basic examples of DataView.Rowfilter

这篇关于如何执行DefaultView.RowFilter进行AND操作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！