*Column name with spaces
string filter = "[job grade] = '" + jobGradeRowsToUpDate[j]["JobGrade"].ToString() + "'";
* NOT IN (item 1,item 2,...)
DataRow[] jobGradeRowsToDelete = currentJobGradeData.Select("jobgrade NOT IN (" + newJobGradeID + ")");
* not equal <>
DataRow[] jobGradeRowsToDelete = currentJobGradeData.Select("jobgrade <> '1'");
Other
Expression Operators
The list of supported operators is somewhat small:
Math Operators:
+ (addition)
- (subtraction)
* (multiplication)
/ (division)
% (modulus, the remainder after division)
String Operator:
+ (concatenation, joining strings)
Comparison Operators:
< (less than) > (greater than)
<= (less than or equal to) >= (greater than or equal to)
<> (not equal to)
= (equal)
IN (compare to a list of items)
LIKE (pattern matching)
Scalar Functions:
Convert (change from one data type to another)
Len (return the length of the string)
IsNull (test for null)
IIf (Immediate If)
Trim (trim white space from string)
Substring (return a part of a string)
Aggregation Functions:
Sum (Sum)
Avg (Average)
Min (Minimum)
Max (Maximum)
Count (Count)
StDev (Standard deviation)
Var (Statistical variance)
**Source: http://home.hot.rr.com/graye/Articles/ADO_Expressions.htm
4 comments:
Thanx Brother you saved my life, i was searching for the not equal to expression.. good work!
Thanks dude!
Was trying NOT EQUAL rather than <>, doh!
viagra jokes female use of viagra no prescription viagra viagra for cheap viagra sample viagra canada viagra sample viagra logo viagra suppliers in the uk viagra uk cheap purchase buy viagra cialis sublingual viagra free trial of viagra viagra results
[url=http://forums.bleachexile.com/member.php?u=57438]digital outdoor camera [/url] and
[url=http://forums.bleachexile.com/member.php?u=57532]chest pain
arthritis pain
leg pain
muscle relaxer
hip pain
[/url]
[url=http://kinopoisk.sms-jet.ru/sitemap.html]скачать фильмы[/url] скачать фильмы
digital camera model and
joint pain
knee pain
back pain relief
muscle relaxer
chronic pain
Post a Comment