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?

 

[Guest]

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

 

[=?ISO-8859-2?Q?Marcin_Grz=EAbski?=]

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

 

[Guest]

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...