Click here to Skip to main content
13,001,686 members (95,251 online)
Rate this:
Please Sign up or sign in to vote.
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!

Posted 29-Jun-13 23:46pm
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!

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170624.1 | Last Updated 30 Jun 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100