A simple example on how to access the SQl database on my PDA

[Ivan Sammut]

Hi ppl.

Can any one give me a simple example on how I connect to my sql database
on my PDA. I created a database named ("Ivan") gave a password & then I
created a table. Now I need to know what is the syntax in my SqlConnection
to connect to then named database.

Sorry if it sounds dumb but just started using it now and can't find an
example on the Internet.

Thanks
Ivan

 

[David D Webb]

http://samples.gotdotnet.com/quickstart/CompactFramework/
has the simplest possible example.

If you are using VS2005, just add a new data source for SQL Mobile. It will
generate an entire class that wraps functionality around creating,
connecting, accessing and deploying the database.

-Dave