how to delete multiple selected checkbox record from datagrid and database

Question

0.00/5 (No votes)

See more:

Hello Everyone,

Please does anyone know how to loop through datagrid in C# Windows application and remove rows that the checkbox values are true, the same way yahoomail works. i have tried this:

C#

private void button1_Click(object sender, EventArgs e)
        {
            List<object > ChkedRow = new List<object >();
            DataRow dr;

            for ( int i = 0 ; i <= dataGridView1.RowCount - 1 ; i++ )
            {
                if ( Convert.ToBoolean( dataGridView1.Rows[i].Cells["chkcol"].Value ) == true )
                {
                    ChkedRow.Add( i );
                }
            }

            foreach ( int k in ChkedRow )
            {
                dr = dt.Rows[k];
                dt.Rows[k].Delete( );
                //dt.Rows.Remove(dr);
            }
        }

But the above code can only remove one record per time, i want to be able to remove more than one record if the user decides. Thanks

Posted 7-Aug-14 5:22am

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)

Dilan Shaminda · Accepted Answer · 2014-08-07T06:39:00

Hi, it is because when you are deleting a row from a gridview the next row will take place of the deleted row.That means if you have stored the indexes of checkboxes which are true, after deleting a row now they have different indexes. I hope it is clear to you. So what you can do is keep a int type variable called countDeletedRows to keep how many rows you have deleted.Then use it as below to delete the records.

Note : i used dataGridView1.Rows.RemoveAt() to delete a datagrid row
Below code will delete all the rows which checkboxes are checked

C#

private void button1_Click(object sender, EventArgs e)
        {
            List<object> ChkedRow = new List<object>();
            int countDeletedRows = 0;

            for (int i = 0; i <= dataGridView1.RowCount - 1; i++)
            {
                if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["chkcol"].Value) == true)
                {
                    ChkedRow.Add(i);

                }
            }
            foreach (int k in ChkedRow)
            {
                dataGridView1.Rows.RemoveAt(k - countDeletedRows);
                countDeletedRows++;
            }
        }