You can also try the remote display control for Pocket PC. I've been able to run it on 2003SE and WM5 handhelds without too much problem. The image is sort of grainy, but turning on Cleartype helped.

On the free end of the spectrum, have you looked at Microsoft's Smart Client sample app TaskVision? http://msdn.microsoft.com/smartclient/codesamples/taskvision/default.aspx It's very basic, but you have the source code if it doesn't do enough.

Ripping out existing infrastructure just to do things "correctly" is usually bad, especially if things are working. Probably better to put controls in place for stored procedures and backend processes. E.g. Use VSS to track all changes to the database. I have been a huge user of T-SQL in the past, and it served me well. Some things just rip along when run right on the database server. You're really just writing your BL in T-SQL. Not that different than running a webservice host directly on the SQL Server, no? With SQL 2005 you can even write you procs in .NET. That being said, it's really hard to separate your TSQL stuff from the database later if you need to scale out. Forget about porting to another rdbms. I have reformed from my past TSQL sins, and don't intend to go back. Unless of course the environment or situation calls fors it.;)

ClickOnce creates a folder for each app in your local settings folder. Mine is here: C:\Documents and Settings\\Local Settings\Apps\2.0\WCMKYTQ4.LLO\WNRQ70YJ.7OX\ Each app gets a funky folder name under there, like: \app..tion_a3097e953761587e_07d6.0003_47249f0b94b273b7\ Your exe and log files will most likely be under there. JR

You can set the background of an area/field using an expression instead of a color value. Use something like this: =IIF(RowNumber(Nothing) Mod 2 = 1, "LightGrey", "White") JR

Use a subquery to return the first storename for each id: select distinct LPNHeader.id, Storename = ( SELECT TOP 1 oh.storename FROM LPNDetail ld LEFT OUTER JOIN OrderDetail od on ld.OrderDtlId = od.Id INNER JOIN OrderShipmentLPN OSL ON LH.id = OSL.LPNHdrId INNER JOIN ShipmentHeader sh on sh.id = osl.shipmentHdrId WHERE LPNHeader.Id = ld.LPNHdrId AND sh.Id = 25 ) FROM LPNHeader