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
 General SQL Server Forums
 Database Design and Application Architecture
 How to create dynamic columns in sql database

Author  Topic 

spshindagi
Starting Member

11 Posts

Posted - 2008-05-03 : 03:19:14
hi,
in the front end i have two fields one is dropdown list another is checboxlist say dropdownlist consist of title name and checkbox list consists of sub title name.on selecting title name from dropdownlist i will be getting respective title name in checkboxlist. here when i select checkboxlist(suppose if there are 6 items in checkboxlist n if i select only 3)then my databse column should generate one dropdownlist selected item and 3 checkboxlist selected item.

Eg: if dropdownlist contains( title1,title2,title3) and checkboxlist contains(chk1,chk2,chk3,chk4,chk5,chk6). if i select title1 from dropdownlist i will be geeting 6 item in checkbox list) if i select only 3 items of checkbox list. then i should be able to create column name by title1,chk1,chk2,chk3


help is appreciated

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2008-05-05 : 04:03:59
The create table statement is well documented in BoL. How you create the statement is between you & your front end code.
By the way, I hope this is some nifty little database utility you are creating - this doesn't sound like a very good idea so far if this is a business application of the usual variety.
Go to Top of Page
   

- Advertisement -