Show multiple rows of datagridview to textbox

Question

0.00/5 (No votes)

See more:

Hello,

I use this to show some data from a datagridview with checkboxes to a textbox.

VB

TextBox1.Text = DataGridView1.Item(3, DataGridView1.CurrentRow.Index).Value

Oke , but how do i select more then one row and show the items seperated with a - between the items ?

For example when select 3 checkboxes

VB

Ben - Eric - John

What I have tried:

<pre lang="vb">  TextBox1.Text = DataGridView1.Item(3, DataGridView1.CurrentRow.Index).Value

This is only displaying one item , when i select 2 checkboxes it is only showing the last one

Posted 19-Jan-19 10:18am

BASSIES

Updated 22-Jan-19 4:28am

Add a Solution

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)

Bryian Tan · Accepted Answer · 2019-01-19T19:28:00

Solution 1

not clear what the structure of your current code, but let assume there is a checkbox on each row with "Chk" name, the name is in the "name" column. You can write a loop to loop through the rows, if checked, capture the name, here is an example.

You can also try dataGridView1.SelectedRows if checking the checkbox will select the row.

C#

List<string> names = new List<string>();
            foreach (DataGridViewRow r in dataGridView1.Rows)
            {
                bool isSelected = Convert.ToBoolean(r.Cells["Chk"].Value);

                if (isSelected)
                {
                    names.Add(r.Cells["name"].Value.ToString());
                }
            }

            MessageBox.Show(string.Join(" - ", names));

Posted 19-Jan-19 19:28pm

Bryian Tan

Comments

BASSIES 20-Jan-19 7:04am

Thanks for your answer Bryian , but i can't transform the code to vb.net.

There is an error

Error converting code
Error message:
CONVERSION ERROR: Conversion for IncompleteMember not implemented, please report this issue in '(DataGridViewRow r ' at character 88

BASSIES 20-Jan-19 9:23am

Found another converter

Dim names As List(Of String) = New List(Of String)
For Each r As DataGridViewRow In DataGridView1.Rows
Dim isSelected As Boolean = Convert.ToBoolean(r.Cells("Chk").Value)
If isSelected Then
names.Add(r.Cells("Product").Value.ToString)
End If

Next
MessageBox.Show(String.Join(" - ", names))

Get an error on names
List(Of String)' cannot be converted to 'String()

Bryian Tan 20-Jan-19 15:52pm

The code seem fine. Did you check what in the "names"?

BASSIES 21-Jan-19 7:47am

I can't start the debug because of the error on names

the error is

List(Of String)' cannot be converted to 'String()

BASSIES 22-Jan-19 8:38am

Bryian ,

Was searching on your hint to look for dataGridView1.SelectedRows

Found this , it works but the text is not seperated with -
Tryed to ajust but no luck

The outcome is BenEricJohn no - between the name's

Dim message As String = String.Empty
For Each row As DataGridViewRow In DataGridView1.Rows
Dim isSelected As Boolean = Convert.ToBoolean(row.Cells("chk").Value)
If isSelected Then
message &= Environment.NewLine
message &= row.Cells("name").Value.ToString()
End If
Next

TextBox1.Text = ("Selected Values" & message)

what do i change here with textBox1.text= (..........

Bryian Tan 22-Jan-19 9:17am

Well, not clear why the list of string wouldn’t work. Anyway, with this route, you can append the “-“ by doing something like &= “-“. The problem with this approach, the output will end up with redundant “-“ at the end. You might need to write another line of code to remove the last trailing “-“

BASSIES 22-Jan-19 10:26am

Thanks Bryian ,

I can remove it if wanted.

BASSIES · Accepted Answer · 2019-01-22T04:28:00

Dim message As String = String.Empty
      For Each row As DataGridViewRow In DataGridView1.Rows
          Dim isSelected As Boolean = Convert.ToBoolean(row.Cells("chk").Value)
          If isSelected Then

              message &= row.Cells("Name").Value.ToString()
              message &= " / "
          End If
      Next


      TextBox1.Text = (message)