How to Sqlce Connection in window mobile 6.0 application

Question

0.00/5 (No votes)

See more:

Hi i am trying to make connection of sqlce3.5 database to window moble6.0 application, but it show the the Error "Path is not correct ",

i have added the System.Data.Sqlce; name space also but still not working,

my database path is " C:\Users\SHAMS\Documents\App.sdf"
when i give this in connection string then it show the error the database path is not corect.

please help me
if u can

many thanks in advance

u can contact me on this id
shams_afridi2002@yahoo.com

Posted 11-Oct-10 18:56pm

ShamsAfridi

Add a Solution

1 solution

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)

Arindam Tewary · Answer 1 · 2010-10-11T19:26:00

Hi,

In mobile device application development, the path is always relative to "Mobile Device" root("Mobile Device" option appears only if you are connected to device or emulator using ActiveSync) instead of C drive. As when at runtime the application is launched using either emulator or device which use "\" as the root path. Emulator or device does not know what is "C:". ;)

Keep your sdf file in side "\" ( which is also called "My Mobile Based Device" then provide the path of sdf.

Example: If your sdf file location is like following :

Inside My Computer --> Mobile Device -->My Windows Mobile Based Device --> <your folder="" name="">\YourSdfFile.sdf

Then in application give the path this way "\<Your Folder Name>\YourSdfFile.sdf"

String sConnString = @"\MyFolder\sample.sdf"

NB: In My computer explorer "Mobile Device" option appears only if you are connected to device or emulator using ActiveSync.