private void btnSave_Click(object sender, EventArgs e) { HouseAreaService.HouseAreaClient _has = new HouseAreaClient(); for (int i = 0; i < dataGridViewHouseArea.Rows.Count; i++) { if (dataGridViewHouseArea.Rows[i].Cells[_colAreaAlreadyInDB.Name].Value != null) { //Update string[] _houseAreaData = new string[3]; _houseAreaData[0] = dataGridViewHouseArea.Rows[i].Cells[_colAreaID.Name].Value.ToString().Trim(); _houseAreaData[1] = dataGridViewHouseArea.Rows[i].Cells[_colAreaName.Name].Value.ToString().Trim(); _houseAreaData[2] = dataGridViewHouseArea.Rows[i].Cells[_colAreaStatus.Name].Value.ToString().Trim(); _has.UpdateHouseArea(_houseAreaData); } else { //Add New string[] _houseAreaData = new string[3]; _houseAreaData[0] = dataGridViewHouseArea.Rows[i].Cells[_colAreaID.Name].Value.ToString().Trim(); _houseAreaData[1] = dataGridViewHouseArea.Rows[i].Cells[_colAreaName.Name].Value.ToString().Trim(); _houseAreaData[2] = dataGridViewHouseArea.Rows[i].Cells[_colAreaStatus.Name].Value.ToString().Trim(); _has.AddHouseArea(_houseAreaData); } } //Delete for (int i = 0; i < _houseAreaList.Count; i++) { _has.DeleteHouseArea(_houseAreaList[i].ToString().Trim()); } MessageBox.Show("Data is saved successfully"); ShowAllHouseAreas(); }