Solved

asp.net, c#

Posted on 2012-04-11
1
293 Views
Last Modified: 2012-04-12
1. Got a project to create web-based application to allow user enter information for car insurance quote, it will have over 200+ parameters that we need to save like address, car information, total driver count...and etc., and they all need to be saved into the database.
Instead of create 200+ fields in the table, do any experts have any other / better solution?

2. The application involve at least 5 steps to complete the quote, do any experts know any better asp.net form generator that we can code instead of using asp.net wizard or panel?
remember we have to allow client update the original information as well. we hope to use same UI to avoid extra coding.

Thanks
0
Comment
Question by:Webboy2008
1 Comment
 
LVL 10

Accepted Solution

by:
Najam Uddin earned 500 total points
ID: 37836190
You have asked a very broad question. In DB you should seggregate field in terms of mutliplicity (like one can have multiple phones), atomicity (like address), how many times filed will be updated, what all fields are frequently read , what fields are read in group. Only then they can be put in different tables
If data is expected to be large in nature consider partioning table.

Use wizard or simple page, it will not make much difference, you have to group your information to be shown in single page and track on which page currently user is. Also take care of transaction, either you will allow user to submit half filled form, or you need to them to fill all infor in one go.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now