mobile application connection string

Question

0.00/5 (No votes)

See more:

hi all, i am creating small windows mobile application, can anyone give me connection string for my vb.net mobile application to sql compact edition. it will be great helpful to me.

Posted 29-Jan-12 8:04am

sameertm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-01-29T08:11:00

Solution 1

Horribly complicated, that:

Data Source=\MyFolder\MyDatebaseName.sdf

Posted 29-Jan-12 8:11am

OriginalGriff

Comments

sameertm 29-Jan-12 14:12pm

here i don't want to mention the c drive name right ?

OriginalGriff 29-Jan-12 14:22pm

Mobile doesn't have a concept of drives - it all hangs off "Mobile Device" which acts as the root of the machine.

Espen Harlinn 29-Jan-12 14:17pm

Not everybody has your vast experience on the subject, the ease the ease with which you just tossed the answer of your head, like so much salad, deserves a 10. As we all enjoy filling out our tax returns at this time of the year - I'll have to deduct 50% from your 10.

OriginalGriff 29-Jan-12 14:24pm

:laugh:
I've still got one - my phone is a Windows Mobile 5 jobbie - and I have knocked up a few SQLCE based apps for it in the past.

Espen Harlinn 29-Jan-12 14:31pm

I still have my HTC Windows Mobile 5 too - with tom-tom and microsoft reader, excellent when travveling :) ( Ok, I'll admit that my primary mobile is now an android, and I've ordered a HTC titan - but those are work phones )

OriginalGriff 29-Jan-12 14:36pm

And the battery lasts a week, it's got a proper keyboard, no bugger wants to steal it, and... :laugh: Yup!

Espen Harlinn 29-Jan-12 14:57pm

Apart from the UI, I think the OS was better than the new Windows Phone - I miss MSMQ as it made development of robust phone applications a lot easier ...

sameertm 29-Jan-12 14:43pm

i have northwind.sdf file on my local drive D:\, so how i have to specify that sdf file into my coding ?

**theanil** · Answer 2 · 2012-01-29T08:14:00

Solution 2

an wonder full article on windows mobile andWindows Mobile App Development Part 5: Intro to using SQL Server CE[^]
you can use same connection string in vb also
[or]If you want the code convert the c# to vb by below link
csharp-to-vb[^]

Posted 29-Jan-12 8:14am

theanil

Comments

sameertm 29-Jan-12 14:15pm

i gone through this, but i count't catch his point, he is so advanced, i am beginer :(