private void Disciplines_Load(object sender, EventArgs e)
{
//dataGridView1.DataSource = MainForm.FunctionOfAdding(nameoftable);
var data1 = new List <Dvapolya>();
Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Date_baseone.Open();
dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Шифр FROM Специальности", Date_baseone);
dabse.OleDbDataReader resulter1 = com1.ExecuteReader();
while (resulter1.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter1[0].ToString().Trim(),
firstpole = resulter1[1].ToString().Trim()
};
data1.Add(mc);
}
comboBox1.DataSource = data1;
comboBox1.DisplayMember = "secondpole";
comboBox1.ValueMember = "firstpole";
}
private void GroupsStudy_Load(object sender, EventArgs e)
{
Date_baseone.Open();
var data1 = new List <Dvapolya>();
var data2 = new List <Dvapolya>();
var data3 = new List <string>();
dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Номер FROM Группы", Date_baseone);
dabse.OleDbDataReader resulter1 = com1.ExecuteReader();
while (resulter1.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter1[0].ToString().Trim(),
firstpole = resulter1[1].ToString().Trim()
};
data1.Add(mc);
}
dabse.OleDbCommand com2 = new dabse.OleDbCommand("Select Фамилия, Имя, Отчество, Шифр FROM Студенты", Date_baseone);
dabse.OleDbDataReader resulter2 = com2.ExecuteReader();
while (resulter2.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter2[0].ToString().Trim() + " " + resulter2[1].ToString().Trim() + " " + resulter2[2].ToString().Trim(),
firstpole = resulter2[3].ToString().Trim()
};
data2.Add(mc);
}
dabse.OleDbCommand com3 = new dabse.OleDbCommand("SELECT DISTINCT (Группы_обучение.Год) FROM Группы_обучение", Date_baseone);
dabse.OleDbDataReader resulter3 = com3.ExecuteReader();
while (resulter3.Read() == true)
{
var mc = resulter3[0].ToString().Trim();
data3.Add(mc);
}
comboBox1.DataSource = data1;
comboBox1.DisplayMember = "secondpole";
comboBox1.ValueMember = "firstpole";
comboBox2.DataSource = data2;
comboBox2.DisplayMember = "secondpole";
comboBox2.ValueMember = "firstpole";
comboBox3.DataSource = data3;
}
private void Students_Load(object sender, EventArgs e)
{
var data1 = new List <Dvapolya>();
Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Date_baseone.Open();
dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Шифр FROM Специальности", Date_baseone);
dabse.OleDbDataReader resulter = com1.ExecuteReader();
while (resulter.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter[0].ToString().Trim(),
firstpole = resulter[1].ToString().Trim()
};
data1.Add(mc);
}
specialnost.DataSource = data1;
specialnost.DisplayMember = "secondpole";
specialnost.ValueMember = "firstpole";
var data2 = new List <Dvapolya>();
var nc = new Dvapolya
{
secondpole = "обучается",
firstpole = "1"
};
data2.Add(nc);
var nc1 = new Dvapolya
{
secondpole = "отчислен",
firstpole = "2"
};
data2.Add(nc1);
priznakotchis.DataSource = data2;
priznakotchis.DisplayMember = "secondpole";
priznakotchis.ValueMember = "firstpole";
}
private void Ocenochki_Load(object sender, EventArgs e)
{
var data1 = new List <Dvapolya>();
Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Date_baseone.Open();
dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Фамилия, Шифр FROM Студенты", Date_baseone);
dabse.OleDbDataReader resulter = com1.ExecuteReader();
while (resulter.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter[0].ToString().Trim(),
firstpole = resulter[1].ToString().Trim()
};
data1.Add(mc);
}
familiya.DataSource = data1;
familiya.DisplayMember = "secondpole";
familiya.ValueMember = "firstpole";
}
private void SwichToSpec_Click(object sender, EventArgs e)
{
Dvapolya specs = new Dvapolya();
specs.Show();
}