Multiple checkbox value into datagridview single coloum

Question

0.00/5 (No votes)

See more:

I'm trying to allow specific checkbox's if checked for the data to be merged and to be inserted into the datagridview single column.

The form is adding column as follows;

table.Columns.Add("Drinks", Type.GetType("System.Int32"))

Then

Checkbox 1 = Coke
Checkbox 2 = Pepsi Checkbox 3 = Fanta

Public Class has the following code;

Dim Drinks As String

Each of the checkbox has the following codes along with their text;

Drinks = "Coke"
The button to generate the information is as follows;

table.Rows.Add(Drinks.ToString)
   DataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill
   DataGridView1.RowTemplate.Height = 100
   DataGridView1.AllowUserToAddRows = False
   DataGridView1.DataSource = table

Therefore if someone selects 'Checkbox1 & Checkbox2' how can i get datagridview coloum 'Drinks' to show coke & pepsi?

What I have tried:

N/A i haven't tried anything as i can't find similar thread

Posted 22-Apr-17 13:56pm

caf20012

Updated 23-Apr-17 12:31pm

Add a Solution

Comments

Kornfeld Eliyahu Peter 23-Apr-17 9:22am

While it is fairly unclear...It seems to me that in any case your code overrides previous values when user checks a checkbox...
When user checks the box for Coke, Drinks will be set to 'Coke'; when user checks the box for Pepsi, Drinks will be set to 'Pepsi' and 'Coke' is gone...
It maybe useful too, to think about an enum for those checkbox (a bit valued enum maybe)...

1 solution

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 · Answer 1 · 2017-04-23T12:31:00

Note that your column can accept only integer value, because of this line:

VB.NET

table.Columns.Add("Drinks", Type.GetType("System.Int32"))

And you're trying to add string (which is wrong!):

VB.NET

Dim Drinks As String
Drinks = "Coke"
table.Rows.Add(Drinks.ToString) 'Note: ToString() method is redundant

If you want to add integer value, you have to check if Checkbox is Checked[^], then to add a row into datatable.

Assuming that each drink has its numeric value, you can use something like this:

VB.NET

'Coke = 1
If CheckBox1.Checked Then table.Rows.Add(New Object(){1})

Multiple checkbox value into datagridview single coloum

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us