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();
}
