how Insert data in table using data datagridview

Question

hiii friends project spacification - windows form application in c# - sql database (service based) example- i have datagridview with checkbox and one DELETE button in my project . and i have 2 table in my database. table1 and table2 both of table have same number of column and same datatype. in datagridview i'm displaying the data of table1. i want to perform a DELETE operation and after deleting that data from table1 it should be moved in table2 abd have have to be delete from its origion table1. i have created it but what happening after if i'm selecting 3 rows ... 1st row moving in table1 to table2 but after that another 2rows are not moved in table2. i'have attached my code below.

Karan Gupta · Answer

private void Deleteb(object sender EventArgs e) { int h; List selectedRows = (from row in dataGridView1.Rows.Cast () where Convert.ToBoolean(row.Cells[column2].Value) == true select row).ToList(); if (MessageBox.Show(string.Format(Do you want to Place {0} items order ? selectedRows.Count) Confirmation MessageBoxButtons.YesNo) == DialogResult.Yes) foreach (DataGridViewRow row in selectedRows) { try { //string StrQuery = INSERT INTO placedorder VALUES ( ' + dataGridView1.Rows[i].Cells[pcode].Value + ' ' + dataGridView1.Rows[i].Cells[name].Value + ' ' + dataGridView1.Rows[i].Cells[weight].Value + ' ' + dataGridView1.Rows[i].Cells[quantity].Value + ' ' + dataGridView1.Rows[i].Cells[date].Value + ' ' + dataGridView1.Rows[i].Cells[supplier].Value + '); string StrQuery = INSERT INTO table2 VALUES ( ' + row.Cells[pcode].Value + ' ' + row.Cells[name].Value + ' ' + row.Cells[weight/gm].Value + ' ' + row.Cells[quantity].Value + ' ' + row.Cells[mfg].Value + ' ' + row.Cells[date].Value + ' ' + comboBox1.Text + '); SqlCommand com = new SqlCommand(StrQuery con); con.Open(); h = com.ExecuteNonQuery(); con.Close(); if (h > 0) { MessageBox.Show(imsertredddd Confirmation); List selectedRows1 = (from row1 in dataGridView1.Rows.Cast () where Convert.ToBoolean(row1.Cells[column2].Value) == true select row1).ToList(); // if (MessageBox.Show(string.Format(Order sucessfully Done. Now you want to give this order to another one also ? selectedRows1.Count) Confirmation MessageBoxButtons.YesNo) == DialogResult.No) foreach (DataGridViewRow row1 in selectedRows1) { con.Open(); com = new SqlCommand(delete from table1 where Pcode=' + row1.Cells[pcode].Value + ' con); int h1 = com.ExecuteNonQuery(); con.Close(); if (h1 > 0) { MessageBox.Show(DeletedOrder sucessfully done to  + comboBox1.Text); } else { } } } else { } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { } } }