How to insert 3 string variable data in same column using C#

Question

1.00/5 (1 vote)

See more:

hello
i have three string variable cb1ID,cb2ID ,cb3ID in my programe and that three content three different value i want parameter string that can insert three string in same colomn.

What I have tried:

i have try this but this is not usefull for me it is doing adition
cmd.Parameters.Add(new SqlParameter("@ID", cb1ID+cb2ID+cb3ID));

Posted 5-Oct-16 3:11am

AZHAR SAYYAD

Updated 5-Oct-16 4:23am

v2

Add a Solution

Comments

[no name] 5-Oct-16 9:15am

"i have try this but this is not usefull for me it is doing adition", yes and what else did you expect it to do? That is exactly what you said you wanted to do and that is what your code is doing. So what is the problem?

AZHAR SAYYAD 5-Oct-16 9:27am

actually there is 3 different variable and i want to store this three variable one by one in database i dont want to addition i want insert into this three variable in database

[no name] 5-Oct-16 9:35am

Okay... so write some code to do that then. How you would expect that to happen with what you wrote is a mystery to me.

Karthik_Mahalingam 5-Oct-16 10:31am

how do you want to store in db table?
as one item or 3 items combined as 'a,b,c' ??

2 solutions

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)

Peter Leow · Answer 1 · 2016-10-05T03:28:00

If those IDs are numbers, of course they will add up using + operator. If you want string, then use the appropriate Convert.ToString Method (System)[^].
BTW, why do you want to concatenate IDs? How are you going to differentiate them subsequently? Rightfully, you should store them separately. Learn more 1NF, 2NF, 3NF and BCNF in Database Normalization[^]

#realJSOP · Answer 2 · 2016-10-05T04:23:00

Solution 2

Assuming you want commas between them:

C#

cmd.Parameters.Add(new SqlParameter("@ID", string.Format("{0},{1},{2}",cb1ID,cb2ID,cb3ID));

Posted 5-Oct-16 4:23am

#realJSOP