public statshome() { InitializeComponent(); SQL.editComboBoxItems(comboBox1, "SELECT COUNT(*) FROM Clients"); SQL.editComboBoxItems(comboBox4, "SELECT COUNT(*) FROM Instructors"); SQL.editComboBoxItems(comboBox6, "SELECT COUNT(*) FROM Appointments"); SQL.editComboBoxItems(comboBox5, "SELECT COUNT(*) FROM Clients Where clientType = 'experienced' "); SQL.editComboBoxItems(comboBox2, "SELECT COUNT(*) FROM Clients Where clientType = 'new' "); SQL.editComboBoxItems(comboBox3, "SELECT COUNT(*) FROM Appointments"); }
public RegisterPage() { InitializeComponent(); //It prepares and limites the different text controls comboBoxUserType.Items.Add("Clients"); comboBoxUserType.Items.Add("Instructors"); comboBoxUserType.Items.Add("Admins"); textBoxUserName.MaxLength = 32; textBoxPassword.PasswordChar = '*'; textBoxPassword.MaxLength = 16; textBoxPassword2.PasswordChar = '*'; textBoxPassword2.MaxLength = 16; textBoxFirst.MaxLength = 24; textBoxLast.MaxLength = 24; textBoxEmail.MaxLength = 64; textBoxPhone.MaxLength = 10; //It loads the Client Type Combobox string clientTypeQuery = "SELECT name FROM ClientTypes"; SQL.editComboBoxItems(comboBoxClientType, clientTypeQuery); }
public DeleteClient() { InitializeComponent(); SQL.editComboBoxItems(comboBox1, "SELECT username FROM Clients"); }
public Deleteins() { InitializeComponent(); SQL.editComboBoxItems(comboBox1, "SELECT username FROM Instructors"); }