Rory Does Windows Mobile Development - SQL Server Mobile Stuff | Rory

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

Follow the Discussion

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

robsoft

Jul 05, 2006 at 8:06 AM

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!
Rory Free Tibet While Supplies Last

Jul 05, 2006 at 8:08 PM

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.
bmargarito

Sep 27, 2006 at 11:58 AM

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
hgsurya

Nov 16, 2007 at 1:14 AM

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

Mar 11, 2008 at 2:59 PM

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