[RESOLVED] list box help!

[chris1990]

if you look at the picture below, i have a listbox which is connected to a database, the database stores a name and an ip address.
Is there another way of doing this without using the database as it wont work. i need to be able to add workstations and remove them.
I would also like the code so that when a name from the list box is selected it will show the ip adress in the IP textbox.

[smUX]

Rather than a database, why not save the list in a file?

And rather than a listbox, why not use a listVIEW? You could have a column for the name and another for the IP address

[DigiRev]

I would store it in a flat text file. No need for a database with something like this.

[chris1990]

pls could you explain how to do this as i have never used a listVIEW or written to a text file

[DigiRev]

pls could you explain how to do this as i have never used a listVIEW or written to a text file

I'm writing an example for you.

[smUX]

I'll let someone else explain listview, I've still not got my head around them...they're a lot more flexible than listboxes though :-)

Loading and saving to a text file is a simple matter, firstly you need to open the file

Open "filename" for Input as #1

Replace the Input with Output if you want to save rather than load (Input is load). Also, some people (me included) suggest not using a static value for the file number (in this case, 1)...I've kept it simple for you. When you're used to loading/saving ask for a better way and we'll give it :-)

Now you need to input/write something

Input #1, datastring

Obviously "datastring" is the variable...this inputs a part of the textfile to the variable "datastring". Change Input to Print to write to the file.

Close 1

This closes the file and ensures that it is saved properly (if you're saving) or available for use (if loading)

If you need to load/save multiple parts, you just enclose it in a loop of some sort (your choice, for/next, do/loop whatever). Most people put a "Do" before and a "Loop while not EOF(1)" after...EOF is End Of File and this basically loops until the file is at the end then closes...it's up to you to make sure each loaded/saved item is different each time it loops (put a variable number in there somewhere and increment it :-))

For instance, if you're saving address(1) to address(10) to "addresses.txt" you'd do:

fre = FreeFile 'Note I added this...this is the trick I told you about
Open "addresses.txt" for Output as #fre
For b = 1 to 10
Print #fre, address(b)
Next b
Close 1

Now loading it back

fre = FreeFile 'Note I added this...this is the trick I told you about
Open "addresses.txt" for Input as #fre
b=0
Do
b=b+1
Input #fre, address(b)
Loop while not EOF(fre)
Close fre

Edit: This has been bugging me for AGES...I *knew* I made the mistake of putting "Close 1" in the load back where it should be "Close fre"...corrected :-)

[zynder]

Store it in a textfile with delimiters a new line or tab.

[Hack]

Is there another way of doing this without using the database as it wont work.

This is exactly what I would do. Why won't it work?