private void btnUpdate_Click(object sender, EventArgs e) { try { AirlinesManager ds = new AirlinesManager(); AirlinesManagerTableAdapters.AirlinesTableAdapter aTable = new AirlinesManagerTableAdapters.AirlinesTableAdapter(); aTable.Fill(ds.Airlines); int selectedID = Convert.ToInt32(cmbID.SelectedValue); DataRow[] dr = ds.Airlines.Select("AirlineID=" + selectedID); dr[0]["Name"] = txtName.Text; dr[0]["AirlineType"] = txtType.Text; dr[0]["SeatsAvailable"] = int.Parse(txtSeats.Text); dr[0]["Meal"] = cmbMeals.SelectedValue; aTable.Update(ds.Airlines); MessageBox.Show("Information Updated", "Confirmed", MessageBoxButtons.OK, MessageBoxIcon.Information); aTable.Fill(ds.Airlines); cmbID.DataSource = ds.Airlines; dgvAirlines.DataSource = ds.Airlines; } catch (Exception ex) { handleException(ex); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if ((txtName.Text == "") || (txtType.Text == "") || (txtSeats.Text == "") || (cmbMeals.Text == "")) { MessageBox.Show("No TextBox can be empty", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { AirlinesManager ds = new AirlinesManager(); AirlinesManagerTableAdapters.AirlinesTableAdapter aTable = new AirlinesManagerTableAdapters.AirlinesTableAdapter(); AirlinesManager.AirlinesRow aRow = ds.Airlines.NewAirlinesRow(); aRow.Name = txtName.Text; aRow.AirlineType = txtType.Text; aRow.SeatsAvailable = int.Parse(txtSeats.Text); aRow.Meal = cmbMeals.SelectedValue.ToString(); ds.Airlines.Rows.Add(aRow); aTable.Update(ds.Airlines); aTable.Fill(ds.Airlines); cmbID.DataSource = ds.Airlines; dgvAirlines.DataSource = ds.Airlines; } } catch (Exception ex) { handleException(ex); } }
private void btnDelete_Click(object sender, EventArgs e) { AirlinesManager ds = new AirlinesManager(); AirlinesManagerTableAdapters.AirlinesTableAdapter aTable = new AirlinesManagerTableAdapters.AirlinesTableAdapter(); aTable.Fill(ds.Airlines); int selectedID = Convert.ToInt32(cmbID.SelectedValue); DataRow[] dr = ds.Airlines.Select("AirlineID=" + selectedID); dr[0].Delete(); aTable.Update(ds.Airlines); MessageBox.Show("Information Deleted", "Confirmed", MessageBoxButtons.OK, MessageBoxIcon.Information); aTable.Fill(ds.Airlines); cmbID.DataSource = ds.Airlines; dgvAirlines.DataSource = ds.Airlines; }