private void Form1_Load(object sender, EventArgs e) { this.loadClient(); if (clientComboBox.Items.Count > 0) { this.employeeTableAdapter = new SeniorCitizensDataSetTableAdapters.EmployeeTableAdapter(); this.employeeTableAdapter.ClearBeforeFill = true; this.employeeDataTable = new SeniorCitizensDataSet.EmployeeDataTable(); this.employeeTableAdapter.Fill(employeeDataTable); this.currentEmployeePosition = 0; this.currentEmployeeRow = (SeniorCitizensDataSet.EmployeeRow)employeeDataTable.Rows[currentEmployeePosition]; this.serviceTableAdapter = new SeniorCitizensDataSetTableAdapters.ServiceTableAdapter(); this.serviceTableAdapter.ClearBeforeFill = true; this.serviceDataTable = new SeniorCitizensDataSet.ServiceDataTable(); this.serviceTableAdapter.Fill(serviceDataTable); this.currentServicePosition = 0; this.currentServiceRow = (SeniorCitizensDataSet.ServiceRow)serviceDataTable.Rows[currentServicePosition]; this.loadEmployee(); this.loadServices(); this.setNavButtonEnabledToFalse(); } }
private void loadServices() { SeniorCitizensDataSetTableAdapters.ServiceTableAdapter serviceTableAdapter = new SeniorCitizensDataSetTableAdapters.ServiceTableAdapter(); serviceTableAdapter.ClearBeforeFill = true; SeniorCitizensDataSet.ServiceDataTable serviceDataTable = new SeniorCitizensDataSet.ServiceDataTable(); try { serviceTableAdapter.Fill(serviceDataTable); servicesComboBox.DataSource = serviceDataTable; servicesComboBox.ValueMember = "ServiceID"; servicesComboBox.DisplayMember = "ServiceID"; } catch (System.NullReferenceException ex) { //ignore } catch (SqlException ex) { MessageBox.Show("Error: " + "\nMessage: " + ex.Message, "loadServices() " + ex.GetType().ToString()); } catch (Exception ex) { MessageBox.Show("Error: " + "\nMessage: " + ex.Message, "loadServices() " + ex.GetType().ToString()); } this.serviceDescriptionTextBox.Text = this.currentServiceRow.ServiceDescription; this.serviceRateHourlyTextBox.Text = this.currentServiceRow.ServiceRateHourly.ToString(); this.serviceRateDailyTextBox.Text = this.currentServiceRow.ServiceRateDaily.ToString(); this.serviceRateWeeklyTextBox.Text = this.currentServiceRow.ServiceRateWeekly.ToString(); }