private void BuildingForm_Load(object sender, EventArgs e) { try { siteAdapter = new SiteTableAdapter(); customerAdapter = new CustomerTableAdapter(); buildingAdapter = new BuildingTableAdapter(); siteAdapter.Connection = cnSql; customerAdapter.Connection = cnSql; buildingAdapter.Connection = cnSql; siteDataTable = new DataSet.SiteDataTable(); customerDataTable = new DataSet.CustomerDataTable(); buildingDataTable = new DataSet.BuildingDataTable(); siteAdapter.Fill(siteDataTable); customerAdapter.Fill(customerDataTable); buildingAdapter.Fill(buildingDataTable); enableForm(false); } catch (Exception ex) { MessageBox.Show(ex.Message); } populateBuildingsList(); populateSitesList(); populateCustomersList(); }
private void SiteForm_Load(object sender, EventArgs e) { try { adapter = new SiteTableAdapter(); adapter.Connection = cnSql; dataTable = new DataSet.SiteDataTable(); adapter.Fill(dataTable); enableForm(false); } catch (Exception ex) { MessageBox.Show(ex.Message); } populateSitesList(); }