Exceptions in published apps

[=?Utf-8?B?Sm9obiBCdW5keQ==?=]

I'm at a loss, i have published a program that works fine when run from code,
but produces exceptions when installed and run. I turned on option strict and
option explicit and turned all of the warnings on, then i went through and
handled all conversions etc until no errors or warnings of any kind were
found. When I run my app from the installation i still get a conversion
error. Any thoughts?

System.InvalidCastException: Conversion from string "" to type 'Integer' is
not valid. ---System.FormatException: Input string was not in a correct
format.
at Microsoft.VisualBasic.CompilerServices.Conversions .ParseDouble(String
Value, NumberFormatInfo NumberFormat)
at Microsoft.VisualBasic.CompilerServices.Conversions .ToInteger(String
Value)
--- End of inner exception stack trace ---
at Microsoft.VisualBasic.CompilerServices.Conversions .ToInteger(String
Value)
at AppTest.Form1.updateTotals()
at AppTest.Form1.retrieveData()
at AppTest.Form1.Form1_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ContainerControl.WndProc(Mess age& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

--
-John
Please rate when your question is answered to help us and others know what
is helpful.

[breitak67]

at Microsoft.VisualBasic.CompilerServices.Conversions .ToInteger(String
Value)
at AppTest.Form1.updateTotals()
at AppTest.Form1.retrieveData()

The data you are retrieving must be bad. In your updateTotals method
you are choking on data that is being parsed from string into integer.
You must have a non-numeric character somewhere. I would look in your
data set for a floating point number or commas or something similar.
Are you sure you are using the same data in both cases? Are you testing
and running a debug version but deploying the release version or
vice-versa?
--
breitak67

[=?Utf-8?B?Sm9obiBCdW5keQ==?=]

I figured it out, i think i was looking at the data too long. The issue was i
was performing a calculation with a "" and that of course did not work. What
threw me off is that the error was in a function called by the sub not the
sub itself.
Thanks
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"breitak67" wrote:

>
at Microsoft.VisualBasic.CompilerServices.Conversions .ToInteger(String
Value)
at AppTest.Form1.updateTotals()
at AppTest.Form1.retrieveData()

The data you are retrieving must be bad. In your updateTotals method
you are choking on data that is being parsed from string into integer.
You must have a non-numeric character somewhere. I would look in your
data set for a floating point number or commas or something similar.
Are you sure you are using the same data in both cases? Are you testing
and running a debug version but deploying the release version or
vice-versa?
--
breitak67