I want an example app that will connect a windows handheld to a sql server 2005 database. The database will have a table
tblOpenOrders
OrderID Int, primary key
CustomerName varchar(255),
DateOrdered datetime,
Instructions varchar (255)
A handheld will be in a cradle and will maintain a local synched copy of the table. Once the handheld is removed, a user will be able to type in an Order ID and will see the associated table info on screen. The user will be presented with two buttons:
Order Ready
Not Ready
A status table in the handheld will maintain the following
OrderID
OrderStatus ("Ready" or "Not Ready")
DateStatus datetime
When the handheld is returned to the cradle, the status table will be uploaded to SQL Server. Once the upload is verified, the data can be wiped from the handheld.
This is really an example tool so I can evaluate the feasibility of a larger project. Clean source code and a simple but expandable methodology is a must. It need not include the sql server order table, but should include the code for uploading the status data.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Sql Server 2005 database as host system
connected to a Windows XP system
Windows XP system with ActiveSync software connected to a Pocket PC