Re: Local database path in csharp - C# Discussion Boards

Tunisien8615-Apr-10 0:25

15-Apr-10 0:25

Hi,
No i tried the application with the emulator.
regards Smile | :)

Michel Godfroid15-Apr-10 0:41

15-Apr-10 0:41

Well have you deployed it on the emulator then? The emulator does not have access to your local file system. You should copy the database to the device, whether it is an emulator or a real device. I forget how it's done, but you should include your DB file in your project, select properties, and choose some like 'deploy' in the file properties.

Tunisien8615-Apr-10 3:49

15-Apr-10 3:49

Hi,
As I read,I go to the emulator's file menu->configure.. I added the shared file:\\Admin-PC\GMAOMobile
I added the path in my code as i found in the data->add data source

//Create the connection
            string chcc = @"Data Source=.\BaseGmaoLocale.sdf";
            SqlCeConnection sqlceconn = new SqlCeConnection(chcc);

But still not working
I feel really crazy about this error
any help
regards
Unsure | :~

Michel Godfroid15-Apr-10 4:16

15-Apr-10 4:16

You really have to copy the file to the emulator, not share the file with the emulator. Since your path indicates that it is in the current directory, copy it to the directory where your program resides.
The emulator also doesn't come with SQLCE, you will have to deploy it also, but I suppose the IDE does this for you ( you do have a reference to System.Data.SQLServerCe, do you?)
Have a llok at this tutorial: http://dotnetperls.com/sqlce-database-use[^]

Tunisien8615-Apr-10 4:47

15-Apr-10 4:47

Hi,
I tried with the physical path of my database

//Create the connection
            string chcc = @"Data Source = C:\\Users\\Admin\\Documents\\Visual Studio 2008\\Projects\\GMAOMobile\\ModeDifféré\\BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn = new SqlCeConnection(chcc);

but not still not working.
Concerning u note,I don't understand what u mean by:

The emulator also doesn't come with SQLCE, you will have to deploy it also,

For the reference,I have the reference System.Data.SQLServerCe
Thanks for u help Smile | :)

Michel Godfroid15-Apr-10 5:24

15-Apr-10 5:24

Yes that's the physical path on your PC, but the program will not run on your PC, will it?

The Emulator, or your smart device comes empty: it does not have the .net framework, it does not have SQL CE, it has just the OS, and some manufacturer or Microsoft supplied programs. .Net and SQLCE come in .cab files, supplied by Microsoft. When you copy your program to the emulator or to the the phone, Visual studio creates a deployment package that contains all these files(choosing the right ones for the processor type of your device), and copies this deployment package to the device. The emulator or the smart device will not have access to any files on your pc. So if your database file is stored somewhere on your PC, the emulator will not be able to reach it;
The database file probably does not exist on your PC either, except if you have created it using SQL CE for PC; The only thing that exists is an empty sdf file in the development environment. You've probably created the data connection in the ide, and it's now sitting in the 'server explorer' pane (the left pane in visual studio). Now add this data connection to your project (probably the right pane).
From then on, everything should be automatic. Visual studio will build the packages, select the cab files, copy them to your device, start the remote debugger....
Now, You've probably messed around so long with your project that a lot of the settings are messed up.
Start afresh, create a new project, a new database, and don't use any of the settings from the other project. Follow the tutorial exactly, and try to understand what is happening at each step. Once you have the tutorial running, create another new project, and this time use your specifications and your requirement. Test each step along the way, and if something does not work, check what you have done differently from the tutorial.

Tunisien8615-Apr-10 6:23

15-Apr-10 6:23

Hi,
Thanks a lot for u explanation.I vote for it.I follow u steps and the link bellow:http://msdn.microsoft.com/en-us/library/aa289160%28VS.71%29.aspx#grfvsdcopyingfilestotheemulator[^]
But still the same problem.I am fed up really of this exception.
I want to mention that when going to visual studio:menu tools->connect to device->connect and then to start->Progams->File explorer I found in the storage card my shared file \\Admin-PC\GMAOMobile.Can I use the storage card option to connect to my database??
thanks

Michel Godfroid15-Apr-10 6:50

15-Apr-10 6:50

I suppose you mean GMAOMobile.Cab. That's not the database. It's the cab file containing your program.But yes, nothing prevents you from putting the database on the storage card. Copy the DB (the sdf file) from the pc to the storage card, and, and refer to it as \\Storage card\GMAOMobile.sdf. (Don't know what your storage card is called, but it should appear as a directory in your mobile device).

Tunisien8616-Apr-10 0:26

16-Apr-10 0:26

Hi,
Really I was googling all the day but I don't know how to add my .sdf file to my storage card nor to refer it.I followed this link http://msdn.microsoft.com/en-us/library/aa289160%28VS.71%29.aspx#grfvsdcopyingfilestotheemulator[^]
But really when I was in the step of Using a Shared Folder on the Development Computer,I not found the network share option it talks about.
Any help will be very grantful
Thanks

Michel Godfroid16-Apr-10 0:50

16-Apr-10 0:50

Just out of curiosity, what version of visual studio are you using? (The instructions you pointed to were for visual studio 2003)

Tunisien8616-Apr-10 0:54

16-Apr-10 0:54

Hi,
I use Visual Studio 2008.
regards

Tunisien8619-Apr-10 5:15

19-Apr-10 5:15

Hi,
This is the link that solved my problem:
http://social.msdn.microsoft.com/Forums/en-US/vssmartdevicesvbcs/thread/0f32993e-5b16-43b4-b7b6-09a3f66eb2f2/[^]
Thanks a lot

convert vb.net to c#

toto_201014-Apr-10 23:24

14-Apr-10 23:24

hello everyone

I would like to know how to convert vb.net code in c#.
thanks

OriginalGriff14-Apr-10 23:30

OriginalGriff

14-Apr-10 23:30

Google[^] not working where you are?

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

toto_201014-Apr-10 23:39

14-Apr-10 23:39

Thank you for your reply, but after a rechreche on google, I found many solution, but I preferred to have the opinion of someone who already work in this direction, and thank you again.

Luc Pattyn14-Apr-10 23:46

Luc Pattyn

14-Apr-10 23:46

for small snippets I use http://converter.telerik.com/[^]; I don't have large code bases I would want to convert.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

toto_201015-Apr-10 0:08

15-Apr-10 0:08

thanks.

Eddy Vluggen14-Apr-10 23:57

Eddy Vluggen

14-Apr-10 23:57

The SharpDevelop IDE can convert those files automatically Smile | :)

I are Troll Suspicious | :suss:

toto_201015-Apr-10 0:42

15-Apr-10 0:42

I downloade SharpDevelop but I don't now how to use it ?
thank .

Eddy Vluggen15-Apr-10 0:45

Eddy Vluggen

15-Apr-10 0:45

Open your solution, open the file that you want to convert, and select the menu "Convert code to" from the "Tools" menu Smile | :)

I are Troll Suspicious | :suss:

toto_201015-Apr-10 1:11

15-Apr-10 1:11

thanks

Pete O'Hanlon15-Apr-10 2:37

Pete O'Hanlon

15-Apr-10 2:37

There's a handy Visual Studio 2008 addin called MoXAML Power Toys[^] that does this.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Help on changing Text value

thatraja28-Jan-12 5:52

thatraja

28-Jan-12 5:52

Check this blog post .NET Code Conversion[^]

thatraja

FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI | Nobody remains a virgin, Life screws everyone Sigh | :sigh:

Saiyed Alam14-Apr-10 21:38

Saiyed Alam

14-Apr-10 21:38

Hello friends I have a Observable collection in my wpf window.
There is a textblock in my window which text initially should be "No Message yet" (when Observable collection is empty).
What I need to do is to set the text value of that textblock to " " when Observable collection changes (count becomes > 0)

how Can I do this.?

Any help or hints would be highly appreciated.

Thanking in Advance
Johnny

Re: Help on changing Text value

Michel Godfroid14-Apr-10 21:47