Rory Does Windows Mobile Development - SQL Server Mobile Stuff

Download this episode

Download Video

Description

This screencast is an introduction to using SQL Server Mobile as a local data repository for your Windows Mobile applications.

I walk you through the creation of a SQL Mobile database, how to deploy the DB with your app, how to tie into the data source, and then how to get the IDE to do the rest of the work for you Smiley

As always, you can read about my day job here, or visit my blog here.

Screencasts In This Series:

An Introduction To Windows Mobile Development

- Building a Simple Web Browser With the .NET CF 2.0

- A Simple Data Driven Windows Mobile App Using SQL Server Mobile

- Data Synching: Part One

- Data Synching: Part Two

- Windows Mobile 5.0: State Notification API

- Windows Mobile 5.0: Pocket Outlook Object Model

- Windows Mobile 5.0: Camera API

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      robsoft
      Hey Rory, really enjoying this so far.

      But I've hit a snag with this episode. I'm totally new to C# programming and this is my first time in VS2005 so if this is a really dumb question, apologies in advance!

      After following your instructions I've got the channel9demo data app running. I enter a new record and the ID appears to remain as null. Which means that when I try to enter a second record, I get an exception. I guess that the code which you put in to handle the ID, where if the text length <1 then set it to be a new guid, doesn't seem to be firing.

      In your demo, at the end where you are looking at your new record back in the data grid screen, you can also see your ID field is still null. So I'm *fairly* sure it's something to do with the approach of the demo rather than something unique to me.

      I appreciate that your demo was more about showing how to talk to mobile SQL Server etc than the finer points of dataset programming, but if you could suggest a way to get this working it would be cool.

      Thanks!
    • User profile image
      Rory
      robsoft wrote:
      Hey Rory, really enjoying this so far.

      But I've hit a snag with this episode. I'm totally new to C# programming and this is my first time in VS2005 so if this is a really dumb question, apologies in advance!

      After following your instructions I've got the channel9demo data app running. I enter a new record and the ID appears to remain as null. Which means that when I try to enter a second record, I get an exception. I guess that the code which you put in to handle the ID, where if the text length <1 then set it to be a new guid, doesn't seem to be firing.

      In your demo, at the end where you are looking at your new record back in the data grid screen, you can also see your ID field is still null. So I'm *fairly* sure it's something to do with the approach of the demo rather than something unique to me.

      I appreciate that your demo was more about showing how to talk to mobile SQL Server etc than the finer points of dataset programming, but if you could suggest a way to get this working it would be cool.

      Thanks!


      Whoah. OK. Good call.

      I'll take a look and see why that happened the way it did.

      I'll email you and post here when I have a response.

      Thanks for pointing that out.
    • User profile image
      bmargarito

      Rory,

      I'm new to SQL Server and mobile device applications as well and I think I'm running into a similar problem.  When I run the application in the emulator and click "New" I recieve an Exception "Cannot bind data to the datasource..."

      Did you happen to ever resolve this issue?  Any help would be great.

      Brandon Williams
      Washington State University

    • User profile image
      hgsurya
      Hi Rory,

      i recenttly bought a HTC Touch Windows Mobile 6 phone.
      i want to create my applications and deploy them on this phone.
      Is it possible in this phone?

    • User profile image
      idlegravity
      Won't Guids automatically be generated in the ID column if you set the "Is RowGuid" property to True?  It appears to be so...

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.