private void setPlaceComboBox() { AccountTypeComboBox.SelectedIndex = 0; placeComboBox.Items.Clear(); if (!login.permission) { placeComboBox.Items.Add(new ComboboxItem(login.cityName, login.cityID)); placeComboBox.SelectedIndex = 0; placeComboBox.Enabled = false; } else { try { SqlManipulator sql = new SqlManipulator(); var cities = sql.queryCities(); foreach (var city in cities) { placeComboBox.Items.Add(new ComboboxItem(city.CityName, city.Id)); } placeComboBox.Enabled = true; placeComboBox.SelectedIndex = 0; } catch (Exception) { throw; } } }
private void ManagerForm_Load(object sender, EventArgs e) { ExtensionMethods.DoubleBuffered(this.usersDataGridView, true); selectedRow = 0; SqlManipulator sql = new SqlManipulator(); try { makeTableUsers(sql.getDataLogin()); //usersDataGridView.Columns[0].Visible = false; var cities = sql.queryCities(); cityComboBox.DataSource = cities; // this.cityTableTableAdapter.Fill(this.daftarDataSet1.CityTable); makeTable(sql.getDataCity()); makeTableUsers(sql.getDataLogin()); makeValidationTable(sql.getValidationData()); startendDate = sql.findMaxminMonthDay(0); this.versionTextBox.Text = global.currentVersion.ToString(); this.versionTextBox.Enabled = false; DGV_SetStyle(this.cityDataGridView); changeCityDGVname(); changeColumnName(); selectedRow = 0; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void setComboBoxCity() { if (login.permission) { try { cityComboBox.Enabled = true; SqlManipulator sql = new SqlManipulator(); var cities = sql.queryCities(); foreach (var city in cities) { cityComboBox.Items.Add(new ComboboxItem(city.CityName, city.Id)); } cityComboBox.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.ToString()); MessageBox.Show("شهری در پایگاه داده وجود ندارد"); } } else { cityComboBox.Items.Add(new ComboboxItem(login.cityName, login.cityID)); cityComboBox.SelectedIndex = 0; cityComboBox.Enabled = false; } }
private void tabControl1_Selected(object sender, TabControlEventArgs e) { if (e.TabPage == tabPage1) { selectedRow = 0; SqlManipulator sql = new SqlManipulator(); try { makeTableUsers(sql.getDataLogin()); /// usersDataGridView.Columns[0].Visible = false; var cities = sql.queryCities(); cityComboBox.DataSource = cities; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } if (e.TabPage == tabPage2) { selectedRow = 0; SqlManipulator sql = new SqlManipulator(); makeTable(sql.getDataCity()); } if (e.TabPage == tabPage4) { try { SqlManipulator sql = new SqlManipulator(); makeValidationTable(sql.getValidationData()); var cities = sql.queryCities(); validCityComboBox.DataSource = cities; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }