Semi-simple SNG Analyzer

[OrcaDK]

I've gotten a bit further since last.

You can get the newest (beta!) version at http://hidden.multitablehelper.com/SNGA.zip

This version only runs for a couple of days since i don't want too many early beta's around, i'll release a new version soon.

Doesn't need installation, you will need the .NET Framework 2.0 though

If you're worried about spyware, adware and such, simply just don't use it, that's the easiest solution - not that there's any of it in here.

Let me know what ya think of it, what you want to see in future versions and such.

[pr0crast]

Every time I try to use it I get this:

[ QUOTE ]
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
at System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
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 SNG_Analyzer.Form1.btnImportSNGs_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message&amp ; m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message&am p; m)
at System.Windows.Forms.Button.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)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/Microsoft.NET/Fra...7/mscorlib.dll
----------------------------------------
SNG Analyzer
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/DOCUME~1/ERICWI~1/LOCALS~...20Analyzer.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_MSIL...dows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_MSIL...089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_MSIL...em.Drawing.dll
----------------------------------------
ZedGraph
Assembly Version: 1.0.1904.4625
Win32 Version: 1.0.1904.4625
CodeBase: file:///F:/Documents%20and%20Setting...3/ZedGraph.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_32/S...ystem.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_MSIL...System.Xml.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///F:/WINDOWS/assembly/GAC_32/S...ansactions.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[/ QUOTE ]

[OrcaDK]

And the db.mdb file is in the same directory as the application? Gimme a sec, i'll look into it.

[pr0crast]

it most certainly is.

[OrcaDK]

Do you have Microsoft Access installed? In case you do, what version? What system are you running?

[turbojunge]

Clicking on "Average Players":

<font class="small">Code:</font><hr /><pre> See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.OleDb.OleDbException: Syntaxfehler (fehlender Operator) in Abfrageausdruck 'HandNumber = 10 AND SNGID IN ()'.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object&amp; executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&amp; executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object&amp; executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteScalar()
at SNG_Analyzer.Form1.makeAveragePlayersGraph()
at SNG_Analyzer.Form1.tabControl1_SelectedIndexChange d(Object sender, EventArgs e)
at System.Windows.Forms.TabControl.OnSelectedIndexCha nged(EventArgs e)
at System.Windows.Forms.TabControl.WmSelChange()
at System.Windows.Forms.TabControl.WndProc(Message&am p; m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message&amp; m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message&amp; m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

</pre><hr />

[kreutz000]

I added my whole HH directory while party was running, and it threw an exception (which was not handled) because the files were in use by another process. I just clicked continue but then the program just hung.

[BradleyT]

[ QUOTE ]
'HandNumber = 10 AND SNGID IN ()'

[/ QUOTE ]

Yo it looks like it's missing a comma seperated list.

[pr0crast]

[ QUOTE ]
Do you have Microsoft Access installed? In case you do, what version? What system are you running?

[/ QUOTE ]
Nope. I have office 2003 installed but I chose not to install access. WinXP Corp.

[Rhett]

Here is what I want: something that lets me search hands like Poker Tracker, but it calculates the change in $EV for each hand. Right now, Poker Tracker tracks chips, but that is somewhat useless for SNG's. I'd like to know how much $EV I make at each level, for each hand, etc.

I'd also like to be able to datamine other players and see where they make or lose their $EV.