Q: 1.#INF

[G .Net]

Hi

Can anybody help with the following?

I'm using a DataAdaptor to write data back to a SQL Server. If the DataTable
contains divide by zero, then understandably 1.#INF is written back to the
database. However, I'd prefer to write back NULL.

Can anybody tell me how to do this?

 

[GhostInAK]

Hello G .Net,

if database_value = double.positiveinfinity then
replace value with dbnull.value
endif

 

[G .Net]

Cheers Ghost

Hello G .Net,

if database_value = double.positiveinfinity then
replace value with dbnull.value
endif