Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Rory Does Windows Mobile Development - SQL Server Mobile Stuff

Download

Right click “Save as…”

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

Tag:

Follow the Discussion

  • 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!
  • RoryRory Free Tibet While Supplies Last
    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.
  • 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

  • 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?

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

Remove this comment

Remove this thread

close

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.