Add Datagridview Rows to Datatable when Checkbox is Checked in C#

Question

i am working with Desktop Application and i am trying to create a datatable from a datagridview. but i only want to add those rows when checkbox is selected or checked. currently i created a datatable from a whole datagridview like this.

DataTable tbl = (DataTable)dataGridView1.DataSource;

I have added a checkbox coloumn inside datagridview.. so please guide me how to add selected rows to a new datatable

Thanks.. Here is the new code Update

for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true)
                    {
                        DataRow dr0 = tbl.NewRow();
                        dr0["ID"] = dataGridView1.Rows[i].Cells["ID"].Value;
                        dr0["BikeCC"] = dataGridView1.Rows[i].Cells["BikeCC"].Value.ToString();
                        dr0["ChassisModel"] = dataGridView1.Rows[i].Cells["ChassisModel"].Value.ToString();
                        dr0["BikeCC"] = dataGridView1.Rows[i].Cells["BikeCC"].Value.ToString();
                        dr0["ChassisModel"] = dataGridView1.Rows[i].Cells["Chassismodel"].Value.ToString();
                        tbl.Rows.Add(dr0);

                    }
                }

                objMdl.RecordTable = tbl;

This is the way i could find to add selected rows into a new datatable... it is lenghty but i am still facing little issues. which i will post in a bit for your look.

And your code works now? In fact your code is some kind of traditional, it's of course lengthy, however you can still use ImportRow to copy the row instead of assigning cells yourself. — King King
– King King, Commented Sep 18, 2013 at 8:19
Yes, it does do the required job, but additionally it is adding copy of all rows to the data grid.. do i have to clear the datatable each time?? — John Sheedy
– John Sheedy, Commented Sep 18, 2013 at 9:20
remember to init tbl as ((DataTable)dataGridView1.DataSource).Clone and check the condition in if-statement, I doubt it's true in all the loops. — King King
– King King, Commented Sep 18, 2013 at 10:19
Thanks alot for your help and time.. yes .Clone did work.. it is solved now :) — John Sheedy
– John Sheedy, Commented Sep 18, 2013 at 10:36

King King · Accepted Answer · 2013-09-18 07:55:09Z

1

Suppose your checkbox column is named yourCheckBoxColumn:

DataTable tbl = ((DataTable)dataGridView1.DataSource).Clone();//Clone structure first
var rows = dataGridView1.Rows.OfType<DataGridViewRow>()
                        .Where(r=>Convert.ToBoolean(r.Cells["yourCheckBoxColumn"].Value))
                        .Select(r=>((DataRowView)r.DataBoundItem).Row);
foreach(var row in rows)
   tbl.ImportRow(row);

edited Sep 18, 2013 at 7:55

answered Sep 18, 2013 at 6:46

King King

63.5k16 gold badges118 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

20 Comments

John Sheedy Over a year ago

Problem when i type in my check box column.. it gives error that column does not belong to table tbl.

King King Over a year ago

Why do you type in CheckBoxColumn? it's for mouse interaction, anyway I still don't get what your problem is now.

John Sheedy Over a year ago

my Checkbox column name is check when i type "Check" for the column name it doesnt find this name inside the datagrid.

King King Over a year ago

@RanaDotnet check or Check? the case-sensitivity is important. Could you show the code to add your checkbox column?

John Sheedy Over a year ago

and when i give index of the column, i get error saying Specific cast is not valid.

|

Collectives™ on Stack Overflow

Add Datagridview Rows to Datatable when Checkbox is Checked in C#

1 Answer 1

20 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

20 Comments

Your Answer

Sign up or log in

Post as a guest

Related