Cast from string "15726451-1364743165280" to type 'Double' is not valid.

[Lord_Rat]

Given:

Try
Dim t As String = e.Item.Cells(3).Text
Response.Write("<h4>" & t & "</h4>")
Dim dd As Double = Double.Parse(t)
'Response.Write(e.Item.Cells(3).Text)
If dd < 0.1 Then
e.Item.Cells(0).BackColor = System.Drawing.Color.FromArgb(&HD1, &H3D, &H47) 'red
ElseIf dd > 100 Then
e.Item.Cells(0).BackColor = System.Drawing.Color.FromArgb(&H81, &HB4, &H4B) 'green
Else
Response.Write(ColorFade(&HEFF773, &HD13D47, dd).ToString & " Color Faded from " & e.Item.Cells(3).Text.ToString() & "<hr>")
e.Item.Cells(0).BackColor = System.Drawing.Color.FromArgb(ColorFade(&HEFF773, &HD13D47, dd))
End If
Catch ee As Exception
Dim i As Integer
For i = 0 To e.Item.Cells.Count - 1
Response.Write(e.Item.Cells(i).Text & " : ")
Next
Response.Write(":No Decimal conversion " & e.Item.Cells(3).Text & ":" & ee.Message & "<br>")
End Try


If e.item.cells(3) is within the range of .99999999 to -.9999999, then the error 'Cast from string "15726451-1364743165280" to type 'Double' is not valid' occurs. I DID NOT attempt to double.parse a string of "15726451-1364743165280"!!

Why is this occurring:

Page output using above code:

0.502680311890838
: : 275 : 0.502680311890838 : 100 : UNASSIGNED : UNASSIGNED : : TS : Outbound : : : : : 6 : : 3 : : :No Decimal conversion 0.502680311890838:Cast from string "15726451-1364743165280" to type 'Double' is not valid.

0.807479804907788
: : 591 : 0.807479804907788 : 100 : UNASSIGNED : UNASSIGNED : : TS : Outbound : : : : : 6 : : 3 : : :No Decimal conversion 0.807479804907788:Cast from string "15726451-1364743165280" to type 'Double' is not valid.

[Lord_Rat]

Please note that values >= 1 or <= -1 will convert without a hitch.