Comments by Burdzy (Top 2 by date)

Burdzy 23-Jul-10 10:42am View

lol, No I didn't type in 18,000 case statements, I don't hate my life that much!! The data was pulled from an IEEE Standards authority Text File. It's a 1 to 1 mapping of Company ID's to registered Company Names. I downloaded the current text file and scripted the creation of the case return statements in EditPlus (Which is a GREAT PROGRAM by the way!!). The reason for not wanting to attach a database is that I am working on Writing a stand-alone executable that I can send out to several people. I don't want to have to worry about installing a DataBase on everyone's computer. As far as I can tell, the list doesn't get updated tooo frequently, so if there is a major update, I would have to update everyones computer anyway, so i am not too worried about it!!

Burdzy 22-Jul-10 13:45pm View

I couldn't use an array as I am using a string as my lookup value. It's a good idea about using a database, but that's really the only information that I have for the company (I am not dealing with address, contacts, etc.) I found another possibility, though I am not sure the implications as I haven't used them much: Since my data really isn't changing much, could I add them all as Resource Strings and then query the resourcemanager using the resourceManger.GetString("Key"); ?? Think that would be quicker/a better approach? I will do some research on the Resource manager, and post any findings. Thanks guys for the quick responses!!