.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

View Complete Post

More Related Resource Links

Mobile WCF: Write an IM App with the .NET Compact Framework


The .NET Compact Framework 3.5 provides a subset of Windows Communication Foundation (WCF) functionality that you can harness to communicate between Windows Mobile devices and desktop PCs. We'll show you how.

Andrew Arnott

MSDN Magazine Launch 2008

Graphics To Go: Make A Mobile Imaging App With The .NET Compact Framework 2.0


This article focuses on developing for Pocket PCs, a skill which can then be transferred to Smartphone application development.

Rob Pierry

MSDN Magazine December 2006

Cannot connect 2010 Access 2010 Excel or PowerPivot to Mobile SQL(SQL Server Compact) - SDF files

I've believe I've installed everything to read Mobile SQL .SDF files.  I've insalled Sql Server Management Studio, Sql Server 2008 R2, .NET 4.0 Framework and just about everything else I've read to see the contents of an .SDF file created for what I read directly from these product sources as this DotNet Compact Framework is the greatest new SQL stuff on the planet.  I can connect using the Management Studio and see the TABLE Stucture easy enough and I can query using some simple SQL Commands from the Management Studio but what really bugs me is if this is all so wonderful, how come I cannot connect to what the SQL Server 2008 R2 Server type "SQL Server Compact" Authentication: "SQL Server Compact Authentication in Office 2010 Access, Excel or even "WOW" PowerPivot!  I've run across a couple 3rd party .SDF Readers - one that exports to Excel such as flyhoward.com  I'm growing old with all the work around import export stuff and just want to use PowerPivot to  excersise the data......or should I use something that actually works like Tableau??

SQL Server Compact v3.5 SqlCeEngine.Upgrade method not working on PocketPC 2003/Windows Mobile 2003

When trying to use the SqlCeEngine.Upgrade(string connectionString) method i get the following exception:

The Parameter is incorrect.
at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
at System.Data.SqlServerCe.SqlCeEngine.Repair()
at System.Data.SqlServerCe.SqlCeEngine.Upgrade()
at Vbi.Compact.ErbisPda.Client.Program.Main()

The same code works like a charm on a Windows Mobile 2005 device. I installed "SQL Server Compact v3.5 Core" and "SQL Server Compact v3.5 Repl" on both devices, the WCE4/Armv4 version on Pocket PC 2003 and the WCE5/Armv4i version on Windows Mobile 2005.

I am hoping someone can help me with this problem, its being a showstopper.

[edit]Please note that i am using v3.5 and not v3.5 SP1. This is because for some of our data access we use a 3rd party library that needs v3.5 without SP1. Also i didn't run across above problem when i deployed my application from Visual Studio 2008 SP1 (debugging), it does occur on a clean system with only the two mentioned SQL Server Compact cabs installed and our app.[/edit]

Mobility: Add Keyboard Support to Compact Framework Apps by Trapping Windows Messages


The Compact Framework Control class doesn't provide direct access to Windows messages. However, with P/Invoke, a few lines of native code, and the Compact Framework MessageWindow class, it's still possible to access underlying Windows messages. This can be used to work around any .NET Framework features, including keyboard support, that are not included in the Compact Framework.

Alan Pulliam

MSDN Magazine April 2004

Windows CE: Develop Handheld Apps for the .NET Compact Framework with Visual Studio .NET


Smart Device Extensions (SDE) for Visual Studio .NET allow programmers to develop applications for the .NET Compact Framework, a new platform that maintains many of the features of the .NET Framework in a version optimized for handheld devices. This article shows how SDE provides access through Visual Studio .NET to a variety of .NET classes for devices running Windows CE, including classes for creating user interfaces. Data access classes and Web Services for the .NET Compact Framework are also explained. Following that overview, a sample Web Service called XMLList is built. Then the UI-the XMLList client-side application-is created.

Larry Roof

MSDN Magazine March 2002

Windows Mobile - Visual Studio 2008 - Erro gravar no banco SQL compact 3.5

Boa noite estou tentando gravar em um banco de dados Compact 3.5 com o  código abaixo. Public Conexao As New SqlCeConnection("Data Source =" & (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) & "\banco.sdf;"))         Dim command As SqlCeCommand = Conexao.CreateCommand()         Conexao.Open()         Dim Trans As SqlCeTransaction = Conexao.BeginTransaction()         command.CommandText = "INSERT INTO clifor (nom, data, numero)VALUES (?, ?, ?)"                command.Parameters.Add("@nom", txtNome.Text)         command.Parameters.Add("@data", txtData.Text)         command.Parameters.Add("@numero", txtNumero.Text)         command.Prepare()         Trans.Commit(CommitMode.Immediate)         command.ExecuteNonQuery()         command.Dispose()         Conexao.Close()

SQL Compact 3.5 and Windows Mobile 6.5.3 emulator

Hi, I have a Windows Mobile Professional 6.5.3 project in VS2008. When I compile and run in, the emulator gives me an error that cannot find the "sqlceme35.dll" library. I guess the SQL Compact 3.5 libraries are not in the emulator, I think the CABs have not been properly delpoyed. How can I install SQL Compact 3.5 in the emulator? I did not have this problem when my project was compiled for Windows Mobile Professional 6.0 platform. Thanks

SQL server 2008 compact editioin + Entity Framework: Can we backup the SQL server compact edition da

our application uses the SQL server 2008 compact edition and entity framework. The application will control the instrument. It may run for several days before it stops. In order to protect the database crash (database failure), we plan to backup SQL compact database during running. Can we backup or duplicate the ~.sdf when application is running? Is there any SQL server command we can call inside the application to achive the backup? Or we only can backup the database when application is not running. thx!  

How to create wsdl proxy of web service with out event handler for .net compact framework 4


Hi All

i have one problem while access web service axis 1.4 in compact frame work

Create web service object using client

 MIScreenSoapClient ser = new MIScreenSoapClient();

create event handler for method to access web service

ser.GetLoginRequestCompleted += new EventHandler<GetLoginRequestCompletedEventArgs>(proxy_getloginrequest);
    ser.GetLoginRequestAsync(strLogin, strPass, Program.VersionNumber, "WM1", "test", "WP7");

Event Handle for method

 void proxy_getloginrequest(object sender, GetLoginRequestCompletedEventArgs e)
   string eee = e.Result;
is there any way to access webservice without call event handler?
Please help me


SQL Server Compact Framework 3.5 SP2 -



Device : Windows Mobile 6.1 Classic / CE OS 5.2.20758 (Build 20758.1.4.1)

I installed SQL CF 3.5 SP2 on this device.

When I run an app ( written by C# CF) that uses SQL simple select statement with coalesce,

I got this error.

The specified argument value for the function is not valid.

[ Argument #= 1, Name of function (if known) = coalesce]


The strange thing is that...

When ran this exactly same app on the different device,

Device : Microsoft Pocket PC / Version 4.20.0 (Build 14053) / 1996 - 2003

It works fine without having any issue.

I even am able to run this app on the emulator without an issue.

Any idea?



create LINQ to database in the .NET Compact Framework 3.5

The article create LINQ to database in the .NET Compact Framework 3.5 was added by suhasharidas on Monday, March 21, 2011.

Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here's some sample data: using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System

Entity Framework + SQL server 2008 compact edition: limitation?


any limitation with SQL Server 2008 compact edtion with Entity Framework 4?



Serving Silverlight Apps from Windows Mobile

Even if mobile dev is not my every day work, thanks to the .Net Compact Framework, it's still .Net programming.

Here is the scenario:

You come back home, you have a windows mobile phone wifi capable and you want to quickly get access to your phone pictures from your home network.
You just activate the Wifi, run my app and then browse to the provided link from any computer on the network.

How to create a windows mobile (Smart Device) .Cab installer

A Cab file is the default setup format for Windows CE and Windows Mobile devices (similar to windows .msi files). You probably already have installed several application using .cab files, and are familiar with the concept. One point which is often unknown is that .cab files are processed by wceloader.exe, and it can only install one .cab file at a time. That means we cannot have nested .cab files. It doesn't mean we cannot have .cab files contained by another .cab, but the contained .cab files will not be installed during the installation of the container .cab. We should install it manually after the container .cab file installation has been completed.

There are two ways to create a cabinet (.Cab) file. The traditional one, and the friendly VS Smart Device Cab project which doesn't require additional coding, but which also relies on the traditional one at low-level.

Bar Code Scanners with the .NET Compact Framework

Summary: Learn how to make your applications use bar code scanners in a generic way-ndependent of the specific bar code scanners that are used on different devices. Using the design patterns Façade and Factory, the implementation not only supports multiple bar code scanners, but it also makes it easy to add support for other bar code scanners. After a brief discussion about bar code scanners and the bar code scanner pattern, a download code sample, written in C#, demonstrates the use of the pattern and technologies.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend