private void Form_Add_Sotrudcs_Load(object sender, System.EventArgs e)
{
comboBox_Dolj.DataSource = connect_DB.TableFill("SELECT Nazv_Dolj, Id_Dolj FROM Dolj", sqlConnection).Tables[0];
comboBox_Dolj.DisplayMember = "Nazv_Dolj";
comboBox_Dolj.ValueMember = "Id_Dolj";
comboBox_Akk.DataSource = connect_DB.TableFill("SELECT Login_, Id_Auto FROM Autoriz", sqlConnection).Tables[0];
comboBox_Akk.DisplayMember = "Login_";
comboBox_Akk.ValueMember = "Id_Auto";
}
private void Form_Dolj_Upd_Load(object sender, EventArgs e)
{
comboBox_Sot.DataSource = connect_DB.TableFill("SELECT F_S, Id_Sotrud FROM Sotrud", sqlConnection).Tables[0];
comboBox_Sot.DisplayMember = "F_S";
comboBox_Sot.ValueMember = "Id_Sotrud";
comboBox_Dolj.DataSource = connect_DB.TableFill("SELECT Nazv_Dolj, Id_Dolj FROM Dolj", sqlConnection).Tables[0];
comboBox_Dolj.DisplayMember = "Nazv_Dolj";
comboBox_Dolj.ValueMember = "Id_Dolj";
}
private void Form_New_Sell_Bilets_Load(object sender, EventArgs e)
{
comboBox_Film.DataSource = connect_DB.TableFill("SELECT Nazv, Id_Afisha FROM Afisha", sqlConnection).Tables[0];
comboBox_Film.DisplayMember = "Nazv";
comboBox_Film.ValueMember = "Id_Afisha";
comboBox_Klient.DataSource = connect_DB.TableFill("SELECT F_K, Id_Klient FROM klient", sqlConnection).Tables[0];
comboBox_Klient.DisplayMember = "F_K";
comboBox_Klient.ValueMember = "Id_Klient";
comboBox_Sotrud.DataSource = connect_DB.TableFill("SELECT F_S, Id_Sotrud FROM Sotrud", sqlConnection).Tables[0];
comboBox_Sotrud.DisplayMember = "F_S";
comboBox_Sotrud.ValueMember = "Id_Sotrud";
}
private void Form_Registry_Load(object sender, EventArgs e)
{
comboBox_Dolj.DataSource = connect_DB.TableFill("SELECT Nazv_Dolj, Id_Dolj FROM Dolj", sqlConnection).Tables[0];
comboBox_Dolj.DisplayMember = "Nazv_Dolj";
comboBox_Dolj.ValueMember = "Id_Dolj";
}
private void Form_New_Film_Load(object sender, EventArgs e)
{
comboBox_G.DataSource = connection_DB.TableFill("SELECT Nazv, Id_ganr_F FROM Ganr_Film", sqlConnection).Tables[0];
comboBox_G.DisplayMember = "Nazv";
comboBox_G.ValueMember = "Id_ganr_F";
}
private void Form_Del_Film_Load(object sender, EventArgs e)
{
comboBox_Film.DataSource = connect_DB.TableFill("SELECT Nazv, Id_Afisha FROM Afisha", sqlConnection).Tables[0];
comboBox_Film.DisplayMember = "Nazv";
comboBox_Film.ValueMember = "Id_Afisha";
}