This is an ongoing project to port existing lookups on the SBOE Web site to ASP.NET using C# as my code behind language for scripting. The new ASP.NET environment is extremely powerful and has been quite interesting to learn more of.

View Sample Lookup Code Behind File (C#)
Actual Live Lookup
Back to Table




This is COM/ATL based Active-X control I created to give me a more sophisticated Treeview control for a high level application. It supports a context menu, fires control events to the control's container, and stores additional info in the treeviews LPARAM data member in each node for a file listing, storage functionality to save or show files selected for a backup (for my FTPBackup project).





View Main Control CPP file
Back to Table




View Main VB.NET File
Back to Table




This was a research project involving the port of a sophisticated user entry and reporting application to C#.NET and to MS SQL Server 2000, from Foxpro.

Sample Class File from Project
Back to Table




As a part of the SBOE Entry Appeals program port to C# Project I decided to use XML to create a data intermediation piece that would allow people to use the application from home via the internet. The ease with which I was able to do this was somewhat surprising, thanks partly to the excellent coverage in Jesse Liberty's Programming C#.

C# Code Behind File
Wrapper class for Client program accessing XML Web Service
WSDL File (Visual Studio's new IDL file format)
Back to Table




This is an ASP.NET lookup I wrote to do some statistical queries into my database for common SBOE stats I wanted to be able to check on online, and also so the staff can get lookup info on some critical processes. ADO.NET and ADODB functions access the end data.

ASP Code Behind File
Back to Table




Electronic filing utility for SBOE (Arizona State Board of Equalization). This was a Visual C++ project, using a Dialog Based App with MFC. A dialog box is used to allow them to specify a file and enter information, and then the utility uploads it to the SBOE website via FTP. Used by property agents to file large bulk filings of various database formats automatically to the SBOE web site. This app is currently in production and used by agents to upload BULK property filings to the SBOE. Feel free to download the EXE to see more of how it works.



View Main CPP File
Back to Table




This is a little project but somewhat useful, it's hard to send password protected ftp sendings to web sites from high level languages like VB - usually the only command for sending an ftp file that is included in the language doesn't ask for any user or password information, not too helpful when connecting to a protected site.  So these are some useful wrappers functions in a basic DLL.  Also early versions of java didn't support connecting to FTP sites which required a password, so these functions came in very useful at one point.

View Main CPP File
Back to Table




For some reason the Foxpro command to change the default printer became buggy with a new version of Windows.  So I wrote some useful printer utilities, to change the default printer, and also to list all the installed printers.  There is also a mapi send email wrapper function in here as well, and a way to write and/or read a string directly into memory (useful for interprocess communication).

View Main CPP File
Back to Table




This is a large project of my own in the last year to write a chat program that could replace icq while adding some security to it to make the communication secure.  It still needs some work but is a functioning alpha at this stage, and allows you to use your own servers, making it useful for an intranet application for, say, a hospital, who wanted to use another mechanism than email.  Uses a lot of nice stuff, threading, complex tree controls, multiple users per client, busy modes, incoming sounds, etc.  50 class files in total so far in project.  I'm hesitant to make this source totally public although if you ask kindly I will let you look it over.  But feel free to download the EXE and signup (just enter bogus info if you want) to get an idea of how it works.

View Main Dialog's Class File
Back to Table



This was a modification to a large scale java application written in an older version of Java using an old custom CORBA implementation which proved to have lots of bugs. I was enlisted to remove the CORBA pieces from it as a transition to moving it over to a more recent version of Java eventually to use J2EE type features, and also to eliminate the bugs caused by the bad CORBA driver. Maricopa county uses this application to calculate parcel sizes for their county assessors to help determine property values for the county valuations each year.

Sample file
Back to Table



I wrote this as a raw class based on the berkeley sockets. Several years ago the MFC socket functions were a bit slow and also, it's nice to have a version of the socket functions which doesn't require MFC for example, for tight downloadable projects over the web. This class has been fully tested and can be used for a variety of purposes as an alternative to the MFC socket connection classes, or to get web stuff on a socket level without relying on the higher level functions.

View Main CPP File
Sample Usage
Back to Table



This is similar to the Socket Class example but now as a COM object for easier invocation from other languages.

View Main CPP File
Sample Foxpro invocation
Back to Table




This routine handles a cgi request for data and returns the data in a formatted structure. I wrote it to allow me to create a remote data piece for foxpro programmatically to create a remote version of the main entry program which could run raw over the internet. I am currently looking at porting this to an XML service type approach with ADO.NET.

View Main CPP File
Back to Table




Here's a sample Perl lookup from the SBOE site.  Pretty much standard stuff but interesting probably for those learning perl. I tried using dbi.pm but found bugs in the dbd:odbc parts of it, especially when handling more than one table at once, so currently I am still using Roth's win32::odbc module to access data.

Agent Lookup - Perl
Web Site Lookup Page
Back to Table




I wrote this in Visual Foxpro for ease of development, a friend wanted a bot to look up info off of the autotrader site and send emails to people who matched a criteria via the autotrader server (which sends emails through the server itself and hides the emails addresses). It was an interesting project.

View Main PRG File
Back to Table