How to insert selected rows value of Gridview into Database in .net

[mohsinsayyad]

I am Developing Windows Form Application in .Net, I want to insert selected rows value of Gridview into database. First Column of my GridView is Checkbox, when user check one or more checkbox from gridview, i want to insert values of respective rows into Database.

[murugavel84]

I am Developing Windows Form Application in .Net, I want to insert selected rows value of Gridview into database. First Column of my GridView is Checkbox, when user check one or more checkbox from gridview, i want to insert values of respective rows into Database.

Try to use this

foreach (DataGridViewRow rw in dataGridView1.Rows)
{
//Ur checkbox verification and insertion of records.
}

[mohsinsayyad]

that only i want to know,how to check which checkbox is checked.

[murugavel84]

that only i want to know,how to check which checkbox is checked.

Hi,

foreach (DataGridViewRow rw in dataGridView1.Rows)
            {
                if (rw.Cells[0].Value != null & Boolean.Parse(rw.Cells[0].Value.ToString())==true)
                {

                }
            } 

Just remove that 0 and replace with the column index of that checkbox. This works.

[mohsinsayyad]

Thank you murugavel.B

[bekoi]

i an devloping a web application on e-recruitment..i have to insert the primary key(which is not shown in the gridview but is in the database) checked values of a grid view inside a separate table in the database..please help...i am working on asp.net.

[sourabhtripathi]

HIDE the key dont show it in gridview !!
if your key is autogenerated then
make it
labelKEY.Visible=false;