Save new lists at runtime.

Posted on 2009-05-18
Last Modified: 2013-11-25
Hi all.
I have to come up with a way to save new lists in a program, but not use a database. I am thinking about My.Settings. How do you make a new stringcollection in the My.Settings? Also open to a diff approach. I will be using a listbox for the source.
Question by:Hawkvalley1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 12

Expert Comment

ID: 24418262
as per requirements there could be many ways to do this, however if there is only one list or a fixed number of lists (eg 3 or 4 or not very much in number) then you may use appSettings to hold these lists otherwise it would be better to write on file system in xml files.

your data is already in dataTables? perhaps. if so , just use datatable.writexml(<filename>,with schema)

if the lists are unique, then use that name for files on file system or give some details to let us provide better options.


Author Comment

ID: 24418384
I have no idea as to how many lists there will be, that will be up to the User and they are built at runtime in one form and the data will be used in a diff form to populate listboxes and comboboxes. I don't expect it to be a high number maybe close to 10 lists at the max and maybe up to 20 items in each list. No dataTables, but it is an interesting idea.

Author Comment

ID: 24418440
The other catch is there will be several list that that will be called by the choice of the first list item. My program will already have a directory for other files, so file based will not be a problem.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 24421655
So how do you make a My.Settings.StringCollection at runtime?
LVL 12

Accepted Solution

needo_jee earned 500 total points
ID: 24428205

though I would prefer to save lists as xml files and then creating a catalog xml file to hold names and path of all other files/lists.

but as per your requirement, here is a link that explains how to add remove keys in configuration files at runtime.

hope, it would help you


Author Comment

ID: 24436377
Well it has been a little while since I heard from you. I am not familiar with xml files and this might have been/still could be an option. What I came up since then is a simple comma separated text file that either just gets read and fills the listboxes/comboboxes or is emptied and reset with a new list if needed. I might need the above link in the future. Do you think xml would be a better choice than what I have, if so it would require more time on your part to teach me the layout and calling the files to load them. I will be encrypting the file which I already understand how to do with text files. I guess my initial concern with IO was the Users machine may have restrictions - but they will just to give my program the permissions for IO-Read/Write. Hope this all makes since. The basic layout is they will build the catalog and then fill the catalog items with lists of strings, my program will then take these lists and populate diff. controls with the data. Thanks for getting back with me.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question