Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 DB Table Design For Checkboxlist Control

Author  Topic 

batott
Starting Member

7 Posts

Posted - 2008-02-04 : 12:24:45
I was just wondering what would be a preferred approach in designing the tables against checkboxlist?

For example I have 3 checkboxlist:

chklVendor
chklModel
chklColor


and each will have lets say 4 - 5 list items.

Here are the different types of approaches that I've seen when designing database tables:

1. Creating tables for each checkboxlist.
2. Creating a single table and storing the values in a comma delimited format.
3. Using XML


Also these attributes will be used in the search form as one of the fields.





rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-04 : 22:37:42
Should design db based on business process instead of checkboxlist.
Go to Top of Page
   

- Advertisement -