【转】DATAGRIDVIEW控制 （续）

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)

{

    DataGridViewRow selectRow = dataGridView1.Rows[e.RowIndex];

    DataSetTableAdapters.CATETableAdapter ca = new DataSetTableAdapters.CATETableAdapter();

    if (ca.GetCateByID((int)selectRow.Cells["cIDDataGridViewTextBoxColumn"].Value) == null)

        ca.InsertCate(selectRow.Cells["cNAMEDataGridViewTextBoxColumn"].Value.ToString());

    else

        ca.UpdateCATE(selectRow.Cells["cNAMEDataGridViewTextBoxColumn"].Value.ToString(), (int)selectRow.Cells["cIDDataGridViewTextBoxColumn"].Value);

}

 

private void dataGridView1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)

{

    DataSetTableAdapters.CATETableAdapter ca = new DataSetTableAdapters.CATETableAdapter();

    ca.DeleteCateByID((int)e.Row.Cells["cIDDataGridViewTextBoxColumn"].Value);

}