private void Search_Adm_Load(object sender, EventArgs e) { bindingNavigator1.Visible = false; //Запрос для вытягивания списка таблиц dtQuery = DB.LoadTable($"select TABLE_NAME from INFORMATION_SCHEMA.TABLES", "Load_all_tables"); //Заполнение combobox списком таблиц QuicklyChangeDB.ComboSettings(dtQuery, "TABLE_NAME", "TABLE_NAME", combo_objectSearch); }
private void Get_Documents_inf_Load(object sender, EventArgs e) { GridViewStyles.ChancheViewGrid(grid_info_all); bs_login.DataSource = dt; bs_KL.DataSource = dt2; dt = DB.LoadTable("SELECT Т_Клиент.ID_Клиента as aa, Т_Клиент.ФИО as bb FROM Т_Клиент", "Т_Клиент"); dt2 = DB.LoadTable($"SELECT * FROM Т_Клиент WHERE ФИО = {comboBox_Klient.Text}", "Т_Клиент"); QuicklyChangeDB.ComboSettings(dt, "ФИО", "ID_Клиента", comboBox_Klient); }
private void Form1_Load(object sender, EventArgs e) { //* in password text_password.UseSystemPasswordChar = true; ToolTip tip = new ToolTip(); tip.Active.ToString(); tip.BackColor = System.Drawing.Color.BlueViolet; tip.SetToolTip(text_password, "Обязательное поле для ввода!"); BindingSource bs_login = new BindingSource(); dt = DB.LoadTable("SELECT * FROM Login", "Login"); bs_login.DataSource = dt; QuicklyChangeDB.ComboSettings(dt, "Access_rights", "ID_rights", combo_login); }
private void Add_Dogovora_Load(object sender, EventArgs e) { BindingSource bs_language = new BindingSource(); BindingSource bs_curator = new BindingSource(); BindingSource bs_sotr = new BindingSource(); bs_language.DataSource = dt_lang; bs_curator.DataSource = dt_curator; bs_sotr.DataSource = dt_sotr; dt_lang = DB.LoadTable("SELECT Т_Языки_прог.КодЯзыка as aa, Т_Языки_прог.Язык as bb FROM Т_Языки_прог", "Т_Языки_прог"); dt_curator = DB.LoadTable("SELECT Т_Кураторы.ID_Куратора as aa, Т_Кураторы.ФИО as bb FROM Т_Кураторы", "Т_Кураторы"); dt_sotr = DB.LoadTable("SELECT Т_Штат_сотрудников.ID_сотрудника as aa, Т_Штат_сотрудников.ФИО as bb FROM Т_Штат_сотрудников", "Т_Штат_сотрудников"); QuicklyChangeDB.ComboSettings(dt_lang, "Язык", "КодЯзыка", comboBox_language_dog); QuicklyChangeDB.ComboSettings(dt_curator, "ФИО", "ID_Куратора", combo_Curator); QuicklyChangeDB.ComboSettings(dt_sotr, "ФИО", "ID_сотрудника", comboBox_sotryd_dog); }