LulzSoft

This is just a quick bugfix for those of you with square screens. Ed Thompson found the bug where square screens were not displaying correctly. I had set anchors when I shouldn’t have, and it should now be fixed. In doing this, I also fixed the landscape(rotation) bug.

Cab: http://www.lulzsoft.com/installers/gasmate_rc.42b.CAB

.Net CF 3.5 https://www.lulzsoft.com/wordpress/2009/08/07/net-cf-3-5-cab/

SQLCE: https://www.lulzsoft.com/wordpress/2009/06/07/sqlce-cab-files-for-ppcs/

As I have opted to respond by email to errors posted, I thought I would give an overview of what certain errors mean, and what to do about them.

If you do not have SQLCE installed, you will get this error:

Gasmate.exe
MissingMethodException
File or assembly name
’system.data.sqlserverce,
version=3.5.0.0 culture=neutral,
publickeytoken=3be235df1c8da2d3′,
or one of its dependencies, was not
found.

The solution to this is to install the SQLCE cabs I have hosted or download it from Microsoft.

If you have an old version of GasMate, you might get an error similar to this:

GasMate.exe
SqlCeException
[ cost ]

at System.Data.SqlServerCe.SqlCeCommand.ProcessResult s(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryP lan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteComman d(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader (CommandBehavior behavior)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbData Reader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at GasMate.GasMateDataSetTableAdapters.maintTableAdap ter.Fill(maintDataTable dataTable)
at GasMate.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form._SetVisibleNotify(Boolea n fVis)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.Run(Form fm)
at GasMate.Program.Main()

The solution to this is to either delete the database, or export your data and modify it to re-import it.

If you have a smartphone(WM Standard), you will get this error:

NotSupportedException
at
Microsoft.AGL.Common.MISC.HandleAR(PAL_ERROR.ar)
at
System.Windows.Forms.Control._InitInstance(WNT wnt, UInt32 dwStyle)
at
System.Windows.Forms.Control..ctor(WNT wnt)
at
System.Windows.Forms.TabControl.ctor()
at GasMate.Form1.InitializeComponent()
at GasMate.Form1..ctor()
at GasMate.Program.Main()

Unfortunately at this time, WM Standard does not support some of the form elements I am using in GasMate. Later on there is the possibility of a fork that will work on WM Standard.

This is a bugfix version with a few features added:

• Decimal separator is now pulled from localization info
• Dollar sign($) is also pulled from localization info
• Last gas type used is remembered
• Added an extra digit to gals and price
• CAB file is now compressed to make it smaller, I will work on the EXE’s next

Grab it here: http://www.lulzsoft.com/installers/gasmate_rc.41b.CAB

Ok everyone…..import is working! However, I have changed the format slightly to make this easier to parse, so exports must be done from this version or higher to be re-imported.  They will NOT overwrite current entries, but if there is a match a message will come up and it will not be entered. The format for the CSV is as follows:

======
Export from GasMate Beta .25b

,Date,ODO,Gallons,Price/Gal,Fuel Type,Total Cost,MPG,Gal/100mi
G,”2009-06-21 12:43:53″,”2345234″,”23″,”23″,”Premium(91)”,”529″,”First”,”First”

,ODO,Work Done,Date,Notes,
M,”23423″,”Oil Change”,”2009-06-21 12:43:53″,”notes lulz”
==========

The G and M in front tell the program that it is a gas or maint row. The last two values in the gas table are NOT necessary in that the program calculates them when it runs, so if you are importing from other data you do not need to worry about them.

Other notes:

• Changed Date format to yyyy-MM-dd HH:mm:ss (fixes bugs when people override date in NLS)
• Added warning before nuking full table

Cab: http://www.lulzsoft.com/installers/gasmate_b.25c.CAB

Please let me know how it works out!

-Daniel