idea needed: displaying insurance names

I need an idea on how to do this. I have a list of insurance companies. For example, 1200 for Florida. I need to display these to the user and have them select as many as they want.

I'm thinking about have this:
1. A dropdownlist displaying states
2. Buttons or hyperlinks to display A thur Z alphabet.
3. A listview to let the user choose what they want from each Alphabet group
4. User selects insurances in each group (for example, 10 insurances that start with A)
5. I save in the database.

Is this a good idea to do? What if the user selects 100 insurances...how do I save 100 items that are selected from the listview to the database ...100 hits? that's no good.
LVL 8
CamilliaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sammySeltzerCommented:
You can use the dropdown option with MULTIPLE option but limit to say 5 or less.

Why do you think someone would want to select 100 insurances?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Navneet.Net Full Stack DeveloperCommented:
Hi!

I think of having Tree View
where nodes are Your Alphabets
and inner nodes with checkbox selection option as places
This will be neat and easy to navigate for user.
-  A
      AAA
      AAB
+ B
+ C
-  D
      DDX
      DDP
.. So on


Thanks!  
 
0
Paul MacDonaldDirector, Information SystemsCommented:
Without knowing more about how your customers/visitors would want to select these items, I'd go with a gridview.  

Then, if they want to organize the list by state, you can let them sort by that column; if they want to organize the list by company name, you can let them sort on that column; etc.  Selection could be done with a checkbox in its own column.
0
CamilliaAuthor Commented:
>>Why do you think someone would want to select 100 insurances?
it's a doctor's office but yes, would a doctor's office accept 100 different insurances...i doubt it.
0
Kamal KhaleefaInformation Security SpecialistCommented:
make checkbox with grouping
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.