DataGridView Multiple selection to textbox with comma

Question

0.00/5 (No votes)

See more:

Hi, please help me on getting datagridview multiple selection to textbox with comma, if i select multiple row i am getting only one rows column to textbox, below is code which i have done so far..

<

C#

private void btnUpdate_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow drv in dataGridView1.SelectedRows)
            {
                textBox1.Text = "";
                bool val = true;
                if (dataGridView1.SelectedRows != null)
                {
                    if (!firstvalue)
                    {
                        textBox1.Text = ",";
                    }
                    textBox1.Text = textBox1.Text + dataGridView1.SelectedCells[1].Value.ToString();
                    val = false;
                }
            }
        }

Posted 22-Apr-11 18:17pm

jaipe

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)

Tarakeshwar Reddy · Answer 1 · 2011-04-22T18:31:00

Solution 1

You are resetting the text instead of appending the comma in the if loop. Your code in the if block should be.

C#

if (!firstvalue)
{
     textBox1.Text += ",";
}

UPDATE SM:
Try:

C#

if (!firstvalue)
{
   textBox1.Text += "," + dataGridView1.SelectedCells[1].Value.ToString();
}

Update #2 Tarak:
Another problem is you are resetting the textBox1.Text = "" for each of the row. You have to move it out of the foreach. Also you need to use the drv and get the value from that.

C#

private void btnUpdate_Click(object sender, EventArgs e)
{
   if (dataGridView1.SelectedRows != null)
   {
       textBox1.Text = "";
       bool firstvalue = true;
       foreach (DataGridViewRow drv in dataGridView1.SelectedRows)
       {      
          if (!firstvalue)
          {
             textBox1.Text += ",";
          }
          textBox1.Text += drv.Cells[1].Value.ToString();
          firstvalue = false;
      }
   }
}

Posted 22-Apr-11 18:31pm

Tarakeshwar Reddy

Updated 23-Apr-11 6:45am

v5

Comments

jaipe 23-Apr-11 0:39am

Hi Tarakeshwar, i am getting only one value to textbox even by trying your advice, kindly advice on the same pls

Sandeep Mewara 23-Apr-11 0:43am

Try the updated answer.

BTW, a simple DEBUGGER use can tell you what is going wrong and where. Try it!

Tarakeshwar Reddy 23-Apr-11 0:48am

I agree, a simple debug would have shown what the problem was.

Tarakeshwar Reddy 23-Apr-11 0:52am

Take a look at the updated solution. You were also resetting the textBox1.Text value in the foreach and that was causing you to see only one value.

Sandeep Mewara 23-Apr-11 0:41am

My 5!
Proposed as answer.

Tarakeshwar Reddy 23-Apr-11 0:47am

In your solution, the first value will not get added to the text box.

Sandeep Mewara 23-Apr-11 0:53am

I am not sure if you said this to me... but I proposed your solution as an answer! :)

Tarakeshwar Reddy 24-Apr-11 1:55am

Thanks Sandeep :)

jaipe 23-Apr-11 4:01am

Hi, i have changed the code, but i am getting the same text of which ever final row is selected, like .. i have selected 4 rows with control key + mouse click
i am getting as ,2008,2008,2008,2008, of column 1

Tarakeshwar Reddy 23-Apr-11 12:46pm

I have updated the solution agan. You were not using drv object and always getting the 2nd selected cell value.

stylez500 · Answer 2 · 2012-03-28T11:22:00

Solution 2

C#

foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
        //Column Num represents col names
    MessageBox.Show(row.Cells[1].Value.ToString());
//////////////The 1 Represent the grid column you want the data from

}

By stylesmylez

Posted 28-Mar-12 11:22am

stylez500