divide by zero error 1

[SavantMan]

Scenario:
A dataset exists with a number of columns in it. I want to add a new column that will divide ColA by ColB.

How I've accomplished this is pretty simple, simply create an instance of DataColumn, and set the .Expression property to ColA / ColB.

The problem is when I get to a row where ColB is 0, a divide by zero error occurs. This seems like it should be something so common that it would be heavily documented and such as to how to handle, but can't find anything.

 

[mansii]

Got this from

http://www.dotnet247.com/247reference/msgs/52/264962.aspx

(Column1 / IIF(Column2 = 0, 1, Column2) ) * IIF (Column2 = 0, 0, 1)

Hope this helps.

mansii

 

[SavantMan]

Thanks mansii --- that handled what I needed.

 

[mansii]

The honor goes to him.
Thank's for the star.