private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 5) { con.Open(); SqlCommand insert = new SqlCommand("insert into invtempdb (fullname, quantity, itmbyp, itmprimary, itmtotal) values(@a,@b,@c,@d,@e)", con); insert.Parameters.Add("@a", dataGridView1.CurrentRow.Cells[1]); insert.Parameters.Add("@b", dataGridView1.CurrentRow.Cells[2]); insert.Parameters.Add("@c", dataGridView1.CurrentRow.Cells[3]); insert.Parameters.Add("@d", dataGridView1.CurrentRow.Cells[4]); insert.Parameters.Add("@e", dataGridView1.CurrentRow.Cells[5]); insert.ExecuteNonQuery(); //con.Close(); insert.ExecuteNonQuery(); MessageBox.Show("value saved"); } else { MessageBox.Show("Not Saved"); } }
DataGridViewTextBoxCell
string value = Convert.ToString((dataGridView1.Rows[e.RowIndex].Cells[1] as DataGridViewTextBoxCell).Value);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)