Why DataTable Select doesn't support A*D

[sunhpj]

I am not sure some one asked it before.

I see that the Select Method of DataTable only supports * before and/or behind the characters. If it is A*D, it exits with exception.

I want to know why it cannot support? Any mechanism to explain this?

[mendhak]

If you're trying to use a wildcard, use %

A%D

[sunhpj]

Sorry, A%D is also invalid, both in MSDN document and my testing.

http://msdn.microsoft.com/en-us/libr...on(VS.71).aspx

a line:

Wildcards are not allowed in the middle of a string. For example, 'te*xt' is not allowed.

[sunhpj]

I actually can guest why it cannot support, because * and % also are operators. if we set column like A*D, API cannot know it is A multiplied by B or A wildcard B.

But Microsoft just throw an exception , not user friendly.

[techgnome]

It's probably a limitation due to trying to keep the implementation as small as possible. But I'm sure there's a workaround....

-tg

[sunhpj]

Hi, even it is not directly supported, I need to implement it myself.

For A*D, and I can just seperate A* and *D

but for free combination, like A*D*B*C*

How can we handle?

[techgnome]

Don't use the .Select method of the DT..... how about using a DataView instead, and setting the filter property?

-tg

[sunhpj]

I actually use DataView.filter.

But the problems are the same