How to loop through datagrid and get values for rows that are checked

Question

0.00/5 (No votes)

See more:

Hello House,

Please does anyone know how to loop through datagrid that has checkbox column, and get values for the rows that are checked?

I can do this in web forms using gridview control with this code:

C#

int rowCount = 0;
            foreach ( DataGridItem DemoGridItem in DemoGrid.Items )
            {
                CheckBox myCheckbox = ( CheckBox ) DemoGridItem.Cells[0].Controls[1];
                if ( myCheckbox.Checked == true )
                {
                    rowCount++;
                    
                }
            }

Please how do i implement the above code in C# Windows application? Thanks in advance.

Posted 11-Aug-14 5:08am

Uwakpeter

Add a Solution

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)

Trung Nguyen Son · Accepted Answer · 2014-08-11T05:14:00

Solution 1

Updated:

C#

int rowCount = 0;
foreach (DataGridViewRow row in DemoGrid.Rows)
{
   DataGridViewCheckBoxCell cell = row.Cells[colCheck] as DataGridViewCheckBoxCell;

   if ( cell!=null && !DBNull.Value.Equals( cell.Value ) && ( bool ) cell.Value == true )
        {
            //Your code here
        }
}

Posted 11-Aug-14 5:14am

Trung Nguyen Son

Updated 11-Aug-14 23:03pm

v3

Comments

Uwakpeter 11-Aug-14 11:29am

How do i get the selected checkboxes rows from the datagrid and which should i use this in?

Trung Nguyen Son 11-Aug-14 11:34am

It's up to your design: where you put the checkbox column.
In this case, the colCheck is the first one.
DataGridViewCheckBoxCell cell = row.Cells[0] as DataGridViewCheckBoxCell;

Uwakpeter 11-Aug-14 11:57am

i am using the checkbox name instead of index,and it is working, i meant i want to be able to extract selected row record(s)(cell values of the selected rows) and stored it variables. Thanks

Trung Nguyen Son 11-Aug-14 12:01pm

You're welcome!
Pls mark this question as answered if it works for you!
Happy coding!

Uwakpeter 11-Aug-14 12:11pm

not working yet, i meant i want to be able to extract/retrieve selected row record(s)(cell values of the selected rows) and stored it variables.

Trung Nguyen Son 11-Aug-14 12:25pm

Use the code below:
row.Cells[columnNumber].Value
or
row.Cells["ColumnName"].Value

Uwakpeter 11-Aug-14 13:18pm

please see what i mean, i am having a datagrid that displays: Name, depositor, date as column header names, and a checkbox in front of each row, i want to be able to select the name, depositor and date of a particular row, if the checkbox in front of it is selected. take for instance i can achieve this using:dataGridView1.Rows[e.RowIndex].Cells[1].Value + ""; if i am using cellClick event of the datagrid. but i want to be able to do this in button click event.

Trung Nguyen Son 11-Aug-14 13:33pm

I think it's far from what you asked for! :)

Trung Nguyen Son 11-Aug-14 13:25pm

Sure, using the above code. Just get the cell values of row inside the if statement (remove rowCount++;)

Uwakpeter 11-Aug-14 13:48pm

it doesnt get the values, it only shows it boolean state(true/false)

Trung Nguyen Son 11-Aug-14 13:57pm

Yes, I meant you loop through all rows, check if the checkbox column is selected, then get variables like:
var name = row.Cells[1].Value;
....

Brs,
--

Uwakpeter 12-Aug-14 2:53am

okay, this was the issue: DataGridViewCheckBoxCell cell = row.Cells["IsChecked"] as DataGridViewCheckBoxCell; when using the cell variable in the if statement(if ( cell.Value == cell.TrueValue )) it always skipped the lines of code inside inside it while stepping through, i.e. the line of code under it will not be executed. if i remove the if statement it works fine, but i need the if statement to be able to check for the checked rows only. Please i will appreciate if you could still assist, i am doing research on it too. Thanks.

Uwakpeter 12-Aug-14 4:20am

i was able to resolve the issue using: if ( cell!=null && !DBNull.Value.Equals( cell.Value ) && ( bool ) cell.Value == true ). Thanks

Trung Nguyen Son 12-Aug-14 5:03am

Great news!

Happy coding!

Trung Nguyen Son 12-Aug-14 4:01am

Try this:
if((bool)check.Cells["IsChecked"].FormattedValue)
....