Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / June 2007

Tip: Looking for answers? Try searching our database.

list of countries File v. Array v. HTML list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
slinky - 18 Jun 2007 20:26 GMT
I want to get an opinion on some .aspx logic. Say for isntance you
have a user data submission form that amongst other things is
gathering STATE and COUNTRY information of which appear in a
dropdownlist.

If one is already using both an .aspx page and is using a SQLserver
database, why not just place these two lists into a table instead of
an array (common in simple HTML pages using CGI) for the STATES and an
awefully-long-often-changing COUNTRY list that is still prevalent in
HTML pages.

Speaking of which, isn't it true that a list of countries in HTML has
to be laboriously edited when sitching to XHTML?

What are the advantages and disadvantages anybody wants to chime in
on. I set up one today using SQL tables and it works fine, especailly
since tomorrow my PM wants another field set up for national capitals!
Forunately all I have to do is add a field and parse/query a flat file
I found on the web in the format of ... Finland,Helsinki

Anyone?
John Timney (MVP) - 18 Jun 2007 21:01 GMT
I guess the only consideration is that its pretty much a  fixed list of
data, countires (and cities) don't appear that often - so whatever appraoch
you decide to sue for storing the data dont keep loading the data from the
DB or File.  Either cache it or stick it into the app object and load it
once into an array you can use over and over.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

>I want to get an opinion on some .aspx logic. Say for isntance you
> have a user data submission form that amongst other things is
[quoted text clipped - 17 lines]
>
> Anyone?

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.