DataTable.Selec()

[Max]

We are seeing strange problems with Select().

We have expression like this DataTable.Select("col1='101'and col2=1") the
returned datarows include col2 =2. If I just do DataTable.Select("col2=2")
it works.

This type of error is not consistent. we are not understanding the random
behavior. Anybody has any ideas on what to check?

[.NET Undertaker]

hi can you post the definition of the DataTable , I mean col2 type and all ?

"Max" wrote:

We are seeing strange problems with Select().

We have expression like this DataTable.Select("col1='101'and col2=1") the
returned datarows include col2 =2. If I just do DataTable.Select("col2=2")
it works.

This type of error is not consistent. we are not understanding the random
behavior. Anybody has any ideas on what to check?

[Marcin Grzêbski]

Hi Max,

Could you try:
DataTable.Select("[col1]='101' AND [col2]=1");
Maybe it is problem with lower case or with separator's
absence between "'101'" & "and".

HTH

Marcin

We are seeing strange problems with Select().

We have expression like this DataTable.Select("col1='101'and col2=1") the
returned datarows include col2 =2. If I just do DataTable.Select("col2=2")
it works.

This type of error is not consistent. we are not understanding the random
behavior. Anybody has any ideas on what to check?

[lynch]

Are you working with .Net Framework 1.1 with SP1?
If so go to Add/Remove programs, remove the .Net Framework 1.1 and then
reinstall it without SP1.
Try the same filter expression again.

Maybe it is a .Net Framework 1.1 SP1 bug as everyone else is complaining...

"Max" wrote:

We are seeing strange problems with Select().

We have expression like this DataTable.Select("col1='101'and col2=1") the
returned datarows include col2 =2. If I just do DataTable.Select("col2=2")
it works.

This type of error is not consistent. we are not understanding the random
behavior. Anybody has any ideas on what to check?