I am not sure if this is the right group but I didn't see languages group.

I have the following statement:

if (e.SourceRow["COL1"] as string != e.TargetRow["COL2"] as string)
{
   // do something
}

The COL1 and COL2 are both double type.  e.SourceRow is System.Data.DataRow
and the indexer will return an object.  When I execute this, it will never
execute inside the braces.
The values of the left and the right are definitely different.  And when
I print out the value of "e.SourceRow["COL1"] as string", it correctly prints
out the value. Same for COL2.  However, the boolean expression returns false,
meaning both values are equal.  How can this be?

I suspect this has something to do with the use of as operator as it is not
meant to be used for value types such as double.  But the operands correctly
convert from object to string and they do print different string values for
each.  Can someone elaborate what is going on?  Nevermind that I shouldn't
be comparing doubles as strings or anything else.  I am just curious why
this works as it is.

Thanks in advance.

Jiho Han
Senior Software Engineer
Infinity Info Systems
The Sales Technology Experts
Tel: 212.563.4400 x216
Fax: 212.760.0540
jhan@infinityinfo.com
www.infinityinfo.com