MySettings and sharing application to other users - data get lost

Question

0.00/5 (No votes)

See more:

Hi all,

I have created a project. I published it - I have setup file and all application files. The metod used is ClickOne. I've got a problem with sharing it...

The thing is that, my application has two parts - 1st is Administator Panel - where he can choose what will be in comboboxes appearing in Employee Panel (I used MySettings), and connect to the database manually, by choosing it from the folder. The database is always the same, but the path is changing, depends on the Account/Area when we are making measurements. 2nd is Employee panel, where clerk can find what to measure, depends what Administrator has put into the comboboxes. Everything is okay with the application - no errors, etc. My question is, if it's possible to create an 'exe' file for the end, which I can put on the shared folder/sharedrive but with amendments to the comboboxes, taht I made on my computer for example (or on the server), and then employees will have an opportunity to start measurements using values that i've entered to the comboboxes.

Now, when I'm trying to do it, I can put data to the comboboxes, and share the file (on server I can see the all amendments that I made for combo) but on other machine, it's not possible, everything is empty. I guess it's not a problem with the code, because it's working on a single one, there must be something with the application after publishing...

Thank you in advance for help!

Matt

Posted 29-Jun-13 23:46pm

LordVovin

Add a Solution

Comments

Mike Meinz 30-Jun-13 6:38am

You can use your database to hold shared custom settings that are to be shared among all of your users. You can do this with all of your shared custom settings other than the database ConnectionString.

LordVovin 30-Jun-13 7:10am

do you mean, to put all the data to the database and store them, for example in table? (Combobox1 to table1, combobox2 to table2...) and then do make databinding for comboboxes?

Mike Meinz 30-Jun-13 7:19am

Whatever data you have currently in MySettings that you want to share across all users should be in the database and not in MySettings. You can use DataBinding fetaure or your own code to load the comboboxes or other controls from the database tables. You don't necessarily have to put the data into separate tables. You could have a generic table with an indicator of which combobox, the values for a specific indicator value populate (example: SELECT col from combotable where whichdata=1 order by col)

LordVovin 30-Jun-13 17:08pm

Thank you Mike! okay, so now my questions is, how to put all items from Multiline textbox (it was previously used to fill MySettings with items for the combobox), to table in access? I cannot find any code, how to do that...

thank you in advance!

LordVovin 30-Jun-13 18:31pm

Okay, not necessary, thank you for your help Mike!

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)