Exceptions in published apps

[John Bundy]

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(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

 

[John Bundy]

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