.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

data exchange between server an mobile device

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


I have a huge problem with the data exchange of a server database and a mobile database( sdf ). At first I load the data with a normal select from the server to my DataSet and then i set the table rows to added and use the DataTableAdapter.Update() command to fill the mobile database.

The problem appears if I do it a second time because I get an exception with a primary key violation. Before i fill my mobile db I delete the whole table with the delete-command.

Why do i get such an exception if no data is in my mobile database??

Kind regards, thomas

View Complete Post

More Related Resource Links

Data Import issues: Access 2003 .mdb to sqlce 3.5 on mobile device

I am trying to download wirelessly or cradled, data from 3 Access 2003 tables into my SQLCE 3.5 datatables. I already have a successful method + web method that uploads data from my sqlce datatables into the Access 2003 tables. I just need feedback to know if I'm headed in the right direction. Web method: Public Function UpdateSqlCeData(ByVal downloadSet As DataSet) As Boolean ' Connect to Access DB here, execute command and populate data set with returned data. Me.Server.ScriptTimeout = 600000 Dim strSql2 As SqlCeCommand Dim oleDbDataset As System.Data.DataSet = New DataSet Dim sqlParam As New SqlCeParameter Dim fhAccDt, fhCeDt As New DataTable strSql2 = Nothing sqlParam = Nothing 'Connection string to connect to access DB Dim FHLiveDB As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testpre\testservertest.mdb") Dim Pbrd As New OleDb.OleDbDataAdapter("SELECT * FROM tblProductBrand", FHLiveDB) FHLiveDB.Open() Pbrd.Fill(oleDbDataset) With strSql2 .CommandTimeout = 600000 .CommandText = "INSERT INTO Product_Brand ([BrandID],[Brand_Name]) VALUES (@Brand_ID,@Brand_Name)" sqlParam = .Parameters.Add("@Brand_ID", SqlDbType.NVarChar, 50, "Brand_ID&

Synchronize group calendar from Sharepoint 2007 (SBS Server 2008) using ActiveSync for mobile device


I've created a Public Folder Calendar on my Exchange Server that our Office Manager uses to inform all our partners and staff (small medical practice) of vacations, group meetings, etc.

I'd like to make this calendar available to mobile devices (1 Windows Mobile, 1 Blackberry, 3 iPhones). I know that individual user Exchange Calendars can sync, but I'm told Microsoft isn't making any effort to make this happen for Public Folder calendars because they're being deemphasized and will disappear in either the next or subsequent version of Exchange. There's a third party product that claims to do this (Outlook AddIn). Since the Public Folder Calendars are being de-emphasized in favor of the Sharepoint calendar, one would think that Activesync would be able to work with the SharePoint group calendar, but apparently that's not the case. Is my best bet still the Add to Outlook product from diditbetter.com?

I need to simulate a proxy server to test mobile device c# application.


I need to simulate a proxy server to test mobile device c# application.

Is there a way to do this? how should I do this. 

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Sorting Data in a GridView Web Server Control

The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

Creating a Smartphone Application and Using Data from SQL Mobile

In this exercise, you will use Visual Studio 2005 to create a Smartphone application. You will associate commands with a mobile device's soft keys, and you will add the ability to scroll through the list of available products (a list of images). You will create a data source for an existing SQL Mobile database, and then test the application in the Windows Mobile 5.0 emulator.

In the following procedure, you will create a new Windows Mobile 5.0 project in Visual Studio.

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.

How to transfer files between computer and mobile device using bluetooth

What is Bluetooth? How can I have it on my computer?

Bluetooth wireless technology is a communication technology that allows two devices to communicate wirelessly. Most of the notebooks are nowadays equipped with bluetooth. For those notebooks or computers that don't, you can use a bluetooth dongle to add the functionality and it just costs you around $5. Although higher price range bluetooth dongles are available but it makes no sense of buying them if you just plan to connect your mobile device to the computer. Look for one that has Bluetooth v2.0 + EDR (Enhance Data Rate) supporting speeds of upto 3Mbps and with Vista support. You can easily have one of that kind in just $5.

Setting up bluetooth to work on your computer

Just Insert the bluetooth dongle in the USB.
It should get detected by your Operating System and should be ready to use. In case it is just detected as a new hardware, you need to install drivers for it that came with your bluetooth dongle (You can try Google to find the drivers).
Once drivers are installed, a bluetooth notification icon will appear in your system tray.
Right Click on it to access Settings (This may vary with your bluetooth dongle).
Make sure you have turned Discovery On (It allow others to see your computer).
Switch On the bluetooth on the mobile device.

server side does not save data when using POST data to another URL using WebRequest


 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?

The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.

Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)




Runtime development for All mobile device



   I am planning to implement a runtime or Environment . which allow any Mobile application to run on top of IT.

  Please give me couple of links or materials to help me out.

Thanks in advance.


Device detection: standard & mobile web applications


I would like to host standard web pages as well as mobile web pages on a single website/virtual directory.


Is there a simple way of sniffing out the machine type and then presenting either web or mobile application depending on the device?

Or is there a better solution other than creating separate website?

Many thanks

Create web site specific to mobile device, how to detect?



I have a website that is written in .Net 2.0 which uses all the nice rich functionality of the web (Ajax, javascript etc..).  However I have noticed that the site does not display very well on mobile devices. 

So therefore I would like to create a more streamlined version of my site that is better tailored to these devices.  However how do detect that the user has come to the site via a mobile device and how can i redirect them to my tailored page

Many thanks in advance

Obtain mobile device screen size



I am trying to get the screenHeight and width:


 // Get MobileCapabilities from current Request.Browser
        MobileCapabilities currentCapabilities = (MobileCapabilities)Request.Browser;
        // get a property of the  browser 
        Response.Write(currentCapabilities.ScreenPixelsHeight +  " <br>");
        Response.Write(currentCapabilities.ScreenPixelsWidth  + " <br>");


 but this is always show that the Height is 480 & the width is 640

I am trying on HTC with Opera Mobile 9.5

Any Advice?

OData and AtomPub: Building an AtomPub Server Using WCF Data Services


Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

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