Guide for Compact Framework Installation

Name	Source	Use
MS Visual Studio .NET 2003 Enterprise Edition	From CD	Handheld Development environment
Microsoft Pocket PC 2003 SDK	http://www.microsoft.com/downloads/ details.aspx?FamilyID=9996b314-0364-4623-9ede-0b5fbb133652&displaylang=en	Emulator for Pocket PC 2003
PrinterCE.NetCF SDK v1.1.3.0	http://www.fieldsoftware.com/ PrinterCE_NetCF_download.htm	For printing functionality as .NET compact currently does not support printing
OpenNETCF Smart Device Framework 1.2	http://www.opennetcf.org/	Add on to Compact Framework with enriched functionality (refer to online help in the website for details)
MS SQL Server CE 2.0	Attached in the mail	DB for handheld

Some tips:

1) After installing the "Microsoft Pocket PC 2003 SDK" you can
run the following from command promt to see the emulator:
C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\ConnectionManager\Bin\Emulator.exe /ceimage
"c:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Emulation\PPC_2003_WWE.bin" /video 240x320x16 /ethernet true
/skin "c:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Emulation\Pocket_PC_Emulator_Skin.xml"

2) Steps for installing MS SQL Server CE 2.0 in the emulator

i) Unzip the attached file in any folder(say "C:\sqlce")
in desktop and share that folder.

ii) Open the emulator using the Tip no 1 above

iii) Navigate using Start-->Programs-->File Explorer. Click on the 3rd icon (depicted as hand in the menubar)

iv) A pop up screen would appear where enter your desktop's Network Identification name (You can get this from My Computer -->Network Identification)

v) Give your desktop's username/password

vi) You will see the shared folder of your desktop.

Copy :a) sscemw20.dll to the Emulator's Windows folder,
b) Rest of the 3 cab files in any folder of Emulator and click on each of them.

vii) This ensures MS SQL Server is installed. You should see the icon (SQLCE Query) under Emulator's Programs.


[ Any files that need to be copied from desktop to emulator follows the above process]


Play around with the Emulator to see the various features.

How To Use Visual Basic .NET to Format a Windows Forms DataGrid That Is Bound to an Array

Creating POOM items using PIE Web pages

Microsft:: Mobile and embedded App development Center

Synchronization. Sections. Pocket PC Developer Network


Josh Holmes - Compact Framework

Voice Command Tutorials

: Technical Articles: Incorporating Pocket Outlook Data into Your Microsoft .NET Compact Framework-based Applications

.NET Compact Framework Development Articles, Sample-code, Reference, etc.

Distributed Communication in Microsoft .NET - ASP.NET Web Services or .NET Remoting

Data Access Strategies for the Microsoft .NET Compact Framework

Creating a B2C Shopping Mart

Inside CLR Hosting
- Kumar Gaurav Khanna

Mono is Fun and Happening

Wake up to Whidbey

.NET Passion- blog Site by Vidya Vrat Agarwal

ASP.NET Home: ASP.NET Whidbey: Migrating from ASP.NET 1.x to ASP.NET 2.0

Generating radio buttion from Stored proc
----------------Case demonstration----------------------------
SELECT RTRIM(insured.ins_name) 'Insured Name',
ins_short_desc 'Type',
ins_type,
policy.Quote_Number 'Quote No',
case when (policy.rejected_flg =1) then 'rejected'
when (policy.cancelled_flag=1) then 'cancelled'
when (policy.RENEWAL_FLAG=1) then 'renewal'
when (policy.bound_date is not null) then 'bound'
end
FROM Table_Name where Where Condition


----------------------------------------------------------------------------------
--------------------Radio button genration--------------------------------


select '' 'Select',
[Insured Name],
[Type],
[Quote No],
' ' ' ',
[Transaction Status],
[Policy No],
(case
when( (
select count(*)
from policy_docs pd
where pd.policy_id = tq.policy_id
and doc_type in ('policy','state_cert','reg'))>0) then
' ' end )' ',
[Effective Date]
from #tmp_query tq
where
( ltrim(@status) = ltrim([Transaction Status])
or @status is null )
and ( ins_type = @ins_type
or @ins_type is null)
and ( [Insured Name] like '%'+@ins_names+'%'
or @ins_names is NULL)
and ( [Policy No] = @policy_id
or @policy_id is null )
and ( [Quote No] = @quote_id
or @quote_id is null)
and ( broker_id=@broker_id
or @broker_id is null)
and ( [Effective Date] = @effective_date
or @effective_date is null)
order by
policy_id desc

drop table #tmp_query--------------------------------------------------------

IPattern.com (Maxim V. Karpov)- VS.Net2005 - Improvements

Whidbey improvements
Benjaminm's notes on Scott Guthrie's ASP.NET Whidbey Presentation