Wrox Programmer Forums
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 3rd, 2006, 09:05 AM
Authorized User
Join Date: Apr 2006
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default Design Strategy

I am having ‘architectural problems’. My requirement seems to be quite simple. I have a database table ZipInfo with five involved fields StateAbbreviation, CityName, ZipCode, ZipID (pkey), and ZipPopulation.

I need a web page that allows a client to:

1) select a State (I am using standard dropdown list and passing parameter to SQL database Select statement)

2) After client selects state and clicks to execute I want to display all zip codes in the selected state. Each row will contain: ZipCode, CityName, ZipPopulation and a check box where the user can add it to his collection.

3) As client selects one or more rows using the checkboxes a textbox monitors the total ZipPopulation of all ZipCodes that have been checked by the client adding to the total when another row’s checkbox is set true.

4) When the client is finished checking checkboxes the textbox will show the total population for all ZipCodes selected. The client will click to finalize their selection and I then need to pass all ZipID’s for the ZipCodes selected by the client to a ClientInfo table in the same database (ClientInfo.SelectedZips where ClientID = active client).

My questions are what is an appropriate strategy for this problem? Can and should I use existing controls that I find in Visual Studio 2005 or will I need to develop my own classes and methods? I can easily pull the data needed using GridView but am having trouble adding the checkboxes. I do not know if I should be loading up a custom array. I need some design strategy guidance that will allow me to create and monitor the checkboxes as the client selects them and to simultaneously display the total mailing population (ZipPopulation) represented by their selection and possible de-selections and then pass the final ZipID’s back to a field in the ClientInfo table.

I have done this in ASP.Net but it was not pretty. Rather than just forcing a solution I want to code an appropriate and reasonably efficient Web 2.0 solution. I come from an ASP.Net background and the new 2.0 tools are somewhat overwhelming. I am using C# for the code behind.

Thank you
Old October 3rd, 2006, 10:59 AM
Friend of Wrox
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts


I have a couple of questions that crossed my after reading your topic:
1-Having some experience with zipcode info (especially from Census Bureau), in your ZipInfo table are there multiple zip codes per city and/or multiple cities per zipcode?;
2-Is there a seperate client table with just clientID and clientName?. Are we talking 3-DB Table, zipInfo, State, and ClientZipInfo, or 4 DB tables?;
3-When the client builds the clientinfo table, is client adding one entry per zipcode? If so, what happens if client adds an existing zip, which creates a duplicate entry?
4- Is the objective here is for the client to know the total mail distribution in his/her assigned area, being state?

Outside of the above questions, I really dont envisioned the need to establish a seperate class. However I am just looking at the design for now.
Old October 3rd, 2006, 11:56 AM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

I have to ask the question of usability here because there are over 42,500 UNIQUE zip codes in the united states so that is an average of about 850 rows of data per state.

Is it logical to think that a user will wade through that many records just to select X number of check boxes?

Would it make more sense to make a sphereical geometery calculation based off of X origin zip code and return only those zip codes that fall within X miles of the orign?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP - Design Strategy snufse ASP.NET 2.0 Basics 1 March 27th, 2008 02:17 PM
Design patterns for web design ceadge HTML Code Clinic 0 June 19th, 2006 11:26 AM
Design help j.gonsalves@ntlworld.com Access 2 August 16th, 2004 10:01 AM
Java Design issue with UML and Design Patterns the_logical_way Apache Tomcat 0 May 31st, 2004 04:02 AM
Applications Infrastructure and Dev. Strategy. azharmateen PHP How-To 2 August 20th, 2003 11:37 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.