// Šù‘¶ƒŒƒR[ƒh‚Ìíœ private void btnDelete_Click(object sender, EventArgs e) { if (dgvTester.Rows.Count > 0) { int rowIndex = dgvTester.CurrentRow.Index; DialogResult dialog = MessageBox.Show("Do you want to delete Measure item no " + dgvTester.Rows[rowIndex].Cells["item_measure"].Value.ToString(), "Note !", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dialog == DialogResult.Yes) { TfSQL tfsql = new TfSQL(); int item_measure = int.Parse(dgvTester.Rows[rowIndex].Cells["item_measure"].Value.ToString()); string sqlDelete = @"delete from m_item where dwr_id = (select dwr_id from m_drawing where dwr_cd = '" + DrawingCd + "') and item_measure = " + item_measure; bool del = tfsql.sqlExecuteNonQuery(sqlDelete, true); LoadItem(); } } }
private void dgvTester_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvTester.RowCount > 0) { if (dgvTester.Columns[e.ColumnIndex] == colDel) { TfSQL tf = new TfSQL(); int itemId = int.Parse(dgvTester.Rows[e.RowIndex].Cells["item_id"].Value.ToString()); string sqlDelete = "delete from m_item where item_id = " + itemId; DialogResult dialog = MessageBox.Show("Do you want to delete Measure item no " + dgvTester.Rows[e.RowIndex].Cells["item_measure"].Value.ToString(), "Note !", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dialog == DialogResult.Yes) { tf.sqlExecuteNonQuery(sqlDelete, false); LoadItem(); } } } }