how to get around using "&" in Filter Expressions

[MrNobody]

I really need to use the "&" logical operator on a data column when using
FilterRow, but apparantly the filter expressions do not support this. Is
there any workaround for this?

[Dave Fancher]

Is this what you're looking for:

DataView dv = new DataView();
dv.Table = <table>;
dv.RowFilter = "Field1=??? and Field2=???";

The RowFilter property of the DataView class and the Select() method of the
DataTable class share syntax with SQL.

"MrNobody" <Mr******@discussions.microsoft.com> wrote in message
news:37**********************************@microsof t.com...

I really need to use the "&" logical operator on a data column when using
FilterRow, but apparantly the filter expressions do not support this. Is
there any workaround for this?

[MrNobody]

Dave, thank you for your reply!

That is not quite what I was looking for.

What I need is to do a bitwise AND operation on a number stored in the
DataTable.

So say the number is 144 and we're concerned with 8 bits.

I need to know if the 8th but is high (128 is 1)

Normally this is an easy expression: 144 & 128 > 0

but without that operator I need to know a workaround

[Dave Fancher]

Sorry! I read "Data Table" and "FilterRow" and just thought you left out an
"&," I'm afraid I can't be of much help on this one.

Good luck!

"MrNobody" <Mr******@discussions.microsoft.com> wrote in message
news:5B**********************************@microsof t.com...

Dave, thank you for your reply!

That is not quite what I was looking for.

What I need is to do a bitwise AND operation on a number stored in the
DataTable.

So say the number is 144 and we're concerned with 8 bits.

I need to know if the 8th but is high (128 is 1)

Normally this is an easy expression: 144 & 128 > 0

but without that operator I need to know a workaround

[James Curran]

"MrNobody" <Mr******@discussions.microsoft.com> wrote in message
news:37**********************************@microsof t.com...

I really need to use the "&" logical operator on a data column when using
FilterRow, but apparantly the filter expressions do not support this. Is
there any workaround for this?

The SQL interpreter build into .Net (used by FilterRow) may not
recognize bitwise &, but TransactSQL does (and presumably what ever data
server you are using does).

So, on your initial query, include a new column which has the data
manipulated as you desired:

Instead of:
Select A,B,C from MyTable"
use
Select A,B,C, (A & 128) as D from MyTable"

Then the RowFilter merely becomes "D > 0"

--
Truth,
James Curran
[erstwhile VC++ MVP]
Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com