how to add columns dynamically in sql from gridview

Question

0.00/5 (No votes)

See more:

i have a dropdownlist which consists of numbers from 1 to 10.
based on user selection respective dropdownlists will get displayed.
i need to store the dropdownlists values in sql database.
My doubt is whether i need to create 10 columns in the database or can i add columns dynamically in db based on user selection.

Posted 2-Apr-13 1:13am

sukumari1

Add a Solution

Comments

kishore sharma 2-Apr-13 7:42am

can you explain little more ,what output you want

sukumari1 2-Apr-13 8:42am

user has to select no.of languages known.
if user selects 3 then 3 dropdownlists will appear. In that they have to select 3 languages.
as an eg, first dropdownlist user may select english, 2nd dropdownlist spanish and it goes on...
my doubt is to create how many columns in database. col1=english, col2=spanish...
because user may select maximum 10 languages. whether i need to create 10 columns or can i add columns at runtime based on user selection.

2 solutions

Solution 1

You can create and add columns to table using following

DataColumn col1= new DataColumn("Col_Name", typeof(string));
Datatable1.Columns.Add(col1);
Datatable1.acceptchanges()

Hope its what you are looking for....

Posted 2-Apr-13 2:47am

T Pat

Updated 2-Apr-13 2:48am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2013-04-02T02:54:00

No, you need only 2 columns:

SQL

CREATE TABLE UserLangs (UserID INT, LangID INT)

where:
UserID is a foreign-key for users (data coming from MyUsers table)
LangID is a foreign-key for languages(data coming from Languages table)

The structure and relationships between tables should looks like:

MyUsers                   UserLangs                Languages
--------                  ---------                ---------
UserID INT (one <-- many) UserID          |-->one) LangID 
...(other fields)         LangID (many----|         ... (other fields)