How store different values at single field in SQL database

Question

1.00/5 (1 vote)

See more:

i am using one Radiabutton ,Two DropDownBox,I want to store All values in Single Field in sql .please help..,

What I have tried:

i have no idea,please please help me

Posted 24-May-16 2:09am

ramesh arunchalam

Updated 24-May-16 2:43am

Add a Solution

Comments

Karthik_Mahalingam 24-May-16 8:11am

why do you want to store like that?
if so, the data will become messy in the table.

ArjunSingh_as 24-May-16 8:22am

Reply with some code how you are doing????

jgakenhe 24-May-16 8:29am

A multivalued attribute is not a good idea. It removes normalization that will lead to data anamolies that will make your data redundant and junky.

My suggestion would be to either create a column for each the .Net controls in your table (easist) or create a new table with those columns where the primary key calls your main table as its foreign key.

3 solutions

Solution 2

Don't.
It's a nasty thing to do because it causes major problems later - you have to "unpack" the single column each time you want to work with any part of it.
Replace the single column with three columns, and store each value separately. It may seem like a little more work, but it saves a heck of a lot of time and effort later.

Posted 24-May-16 2:36am

OriginalGriff

Solution 3

There are two methods in which you can solve your problem.

1. Combine all (Radiabutton ,DropDownBox) value into one and pass that value to SQL query.

C#

string dropDownBoxValue1 = string.Empty;
string dropDownBoxValue2 = string.Empty;
string radioButton1Value = string.Empty;

string combineAllValue = string.Empty;


bool isChecked = radioButton1.Checked;


if(isChecked )
  radioButton1Value=radioButton1.Text;
  
  .......
  .......
  
dropDownBoxValue1 = Convert.ToString(DropDownBox1.SelectedValue);

dropDownBoxValue2 = Convert.ToString(DropDownBox2.SelectedValue);

combineAllValue=radioButton1Value +","+dropDownBoxValue1+","+dropDownBoxValue2

Note :- combineAllValue pass this value to query String.

2. Combine all values in Stored Procedure and then store to table.

Posted 24-May-16 2:43am

ArjunSingh_as

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)

F-ES Sitecore · Accepted Answer · 2016-05-24T02:28:00

Use a varchar field and come up with a format for your data such as "radiovalue|dropdown1value|dropdown2value" and store that in the field as normal. When you read the field do a string.Split on the '|' to separate the values. You could also store the data as xml, or maybe in JSON format, it is up to you.

However in general this is a bad idea as down the line you might want to query the data, eg all records with "1" as the first dropdown value and you won't be able to. It is much better to store data in different fields, or use a one to many relationship between the master record and all the fields that are relevant to it.