}
listBox_group_SelectedIndexChanged_1(object sender, EventArgs e)
{str = listBox_group.SelectedItem.ToString();_group.Text = str;
}
listBox_subject_SelectedIndexChanged_1(object sender, EventArgs e)
{str = listBox_subject.SelectedItem.ToString();_Subject.Text = str;
}
comboBox_stp_SelectedIndexChanged_1(object sender, EventArgs e)
{.Open();_teach1.Items.Clear();= newSqlCommand("SELECT [ID_Type_teacher] FROM [Type_teacher] WHERE [Name_teacher] LIKE '" + comboBox_stp.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [Surname] FROM [Teacher] WHERE [ID_Type_teacher] = '" + IDt.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_teach1.Items.Add((string)r[0]);
}
}.Close();
}
comboBox_teacher_Click(object sender, EventArgs e)
{.Open();IDt = 0;ch = TB_Teacher.ToString();ch1 = TB_group.ToString();ch2 = TB_Subject.ToString();= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE'" + ch + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}IDg = 0;= newSqlCommand("SELECT ID_Group FROM [Grup] WHERE [Group_Name] LIKE'" + ch1 + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}IDs = 0;= newSqlCommand("SELECT ID_Subject FROM [Subject] WHERE [Name_Subject] LIKE'" + ch2 + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}IDst = 0;= newSqlCommand("SELECT [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher] = '" + IDt.ToString() + "'AND [ID_Subject]='" + IDs.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}(IDst == 0)
{(MessageBox.Show("Связи преподаватель предмет не существовало. Создатьее?", "Добавлениесвязи", MessageBoxButtons.YesNo) == DialogResult.Yes)
{= newSqlCommand("INSERT INTO [Teacher_Subject] ([ID_Teacher], [ID_Subject]) VALUES (" + IDt.ToString() + "," + IDs.ToString() + ")", con);.ExecuteNonQuery();= newSqlCommand("SELECT ID_Teacher_Subject FROM [Teacher_Subject] WHERE [ID_Teacher] =" + IDt.ToString() + "AND [ID_Subject]=" + IDs.ToString() + "'", con);
(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}
}
}= newSqlCommand("INSERT INTO [Connect] ([ID_Group, ID_Teacher_Subject]) VALUES ('" + IDg.ToString() + "," + IDst.ToString() + "')", con);.ExecuteNonQuery();= newSqlCommand("SELECT * FROM [Grup]", con);.Show("Связьдобавлена!");.Close();
}
AlI(string s)
{(int i = 0; i < ListBoxTar.Items.Count; i++)(ListBoxTar.Items[i].ToString() == s);;
}
button15_Click_1(object sender, EventArgs e)
{(int i = 0; i < listBox_teach1.SelectedItems.Count; i++)(!AlI(listBox_teach1.SelectedItems[i].ToString())).Items.Add(listBox_teach1.SelectedItems[i]);
}MoreAll_Click(object sender, EventArgs e)
{.Items.Clear();(int i = 0; i < listBox_teach1.Items.Count; i++).Items.Add(listBox_teach1.Items[i]);
}
RemoveAll_Click_1(object sender, EventArgs e)
{.Items.Clear();
}
RemoveOne_Click_1(object sender, EventArgs e)
{per = ListBoxTar.SelectedItems.Count;(int i = 0; i < per; i++).Items.Remove(ListBoxTar.SelectedItems[0]);
}
comboBox_pod1_SelectedIndexChanged(object sender, EventArgs e)
{.Open();_t.Items.Clear();= newSqlCommand("SELECT [ID_Type_teacher] FROM [Type_teacher] WHERE [Name_teacher] LIKE '" + comboBox_pod1.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [Surname] FROM [Teacher] WHERE [ID_Type_teacher] = '" + IDt.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_t.Items.Add((string)r[0]);
}.Close();
}
comboBox_t_SelectedIndexChanged(object sender, EventArgs e)
{.Open();.Rows.Clear();TID = 0;= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE '" + comboBox_t.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}<TC> ConL = newList<TC>();= newSqlCommand("SELECT [ID_Subject], [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher] = " + TID.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{SID = (int)r[0];.Add(newTC((int)r[0], (int)r[1]));
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [Name_Subject] FROM [Subject] WHERE [ID_Subject] = " + ConL[i].SID.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].NameS = (string)rt[0];
}
}
}
(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [ID_Group], [Teo], [Lab], [Exam], [KKP], [PKP], [RPr], [DP], [GAK], [DZ], [One], [Two] FROM [Connect] WHERE [ID_Teacher_Subject] = " + ConL[i].TSID.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].GID = (int)rt[0];[i].teo = (int)rt[1];[i].lab = (int)rt[2];[i].exam = (int)rt[3];[i].kkp = (int)rt[4];[i].pkp = (int)rt[5];[i].rpr = (int)rt[6];[i].dp = (int)rt[7];[i].gak = (int)rt[8];[i].dz = (int)rt[9];[i].one = (int)rt[10];[i].two = (int)rt[11];
}
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [Group_Name] FROM [Grup] WHERE [ID_Group] = " + ConL[i].GID.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].NameG = (string)rt[0];
}
}
}(int i = 0; i < ConL.Count; i++).Rows.Add(ConL[i].NameG, ConL[i].NameS, ConL[i].teo.ToString(), ConL[i].lab.ToString(), ConL[i].exam.ToString(), ConL[i].kkp.ToString(), ConL[i].pkp.ToString(), ConL[i].rpr.ToString(), ConL[i].dp.ToString(), ConL[i].gak.ToString(), ConL[i].dz.ToString(), ConL[i].one.ToString(), ConL[i].two.ToString());.Close();
}
comboBox_group_SelectedIndexChanged(object sender, EventArgs e)
{.Open();_Group.Rows.Clear();= newSqlCommand("SELECT [ID_Group] FROM [Grup] WHERE [Group_Name] LIKE '" + comboBox_group.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}<CC> ConL = newList<CC>();= newSqlCommand("SELECT [ID_Connect], [ID_Teacher_Subject], [Teo], [Lab], [Exam], [KKP], [PKP], [RPr], [DP], [GAK], [DZ], [One], [Two] FROM [Connect] WHERE [ID_Group] = " + GID.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{
Cons.Add(newCon_DGV((int)r[0]));IDT = (int)r[1];teo = (int)r[2];lab = (int)r[3];exam = (int)r[4];kkp = (int)r[5];pkp = (int)r[6];rpr = (int)r[7];dp = (int)r[8];gak = (int)r[9];dz = (int)r[10];one = (int)r[11];two = (int)r[12];.Add(newCC((int)r[0], (int)r[1], (int)r[2], (int)r[3], (int)r[4], (int)r[5], (int)r[6], (int)r[7], (int)r[8], (int)r[9], (int)r[10], (int)r[11]));
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [ID_Teacher], [ID_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher_Subject] = " + ConL[i].IDT.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].IDt = (int)rt[0];[i].IDs = (int)rt[1];
}
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [Name_Subject] FROM [Subject] WHERE [ID_Subject] = " + ConL[i].IDs.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].NameS = (string)rt[0];
}
}
}(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [Surname] FROM [Teacher] WHERE [ID_Teacher] = " + ConL[i].IDt.ToString(), con);(SqlDataReader rt = com.ExecuteReader())
{(rt.Read())
{[i].NameT = (string)rt[0];
}
}
}(int i = 0; i < ConL.Count; i++)
{_Group.Rows.Add(ConL[i].NameS, ConL[i].NameT, ConL[i].teo.ToString(), ConL[i].lab.ToString(), ConL[i].exam.ToString(), ConL[i].kkp.ToString(), ConL[i].pkp.ToString(), ConL[i].rpr.ToString(), ConL[i].dp.ToString(), ConL[i].gak.ToString(), ConL[i].dz.ToString(), ConL[i].one.ToString(), ConL[i].two.ToString());[i].Row_Num = i;
}.Close();
}ID_g;
button_delete_all_Click(object sender, EventArgs e)
{.Open();= newSqlCommand("SELECT [ID_Group] FROM [Grup] WHERE [Name_Group] LIKE'" + comboBox_group.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_g = (int)r[0];
}
}= newSqlCommand("DELETE FROM [Connect] WHERE [ID_Group] =" + ID_g.ToString(), con);.ExecuteNonQuery();.RemoveAt(ConnectingPeople.SelectedRows[0].Index);_group.SelectedIndex = 0;.Close();
}
button_del_Click(object sender, EventArgs e)
{.Open();(int y = 0; y < ConnectingPeople.SelectedRows.Count; y++)
{(int i = ConnectingPeople.SelectedRows[y].Index; i < Cons.Count; i++)[i].Row_Num--;= newSqlCommand("DELETE FROM [Connect] WHERE [ID_Connect] = " + Cons[ConnectingPeople.SelectedRows[y].Index].ID_Connecct.ToString(), con);.ExecuteNonQuery();.RemoveAt(ConnectingPeople.SelectedRows[0].Index);
}_group.SelectedIndex = 0;.Close();
}
button_Otchot_Click(object sender, EventArgs e)
{();
}ExportToExcel()
{.Application exApp = new Excel.Application();.Visible = true;.Workbooks.Add();._Worksheet workSheet = (Excel.Worksheet)exApp.ActiveSheet;
workSheet.Cells[1, 1] = "Распределение нагрузки на";
workSheet.Cells[1, 2] = "2014-2015";.Cells[1, 3] = "учебныйгод";.Cells[2, 1] = "Группа";.Cells[3, 1] = "№ п/п";.Cells[3, 2] = "Дисциплина";.Cells[3, 3] = "Преподаватель";.Cells[3, 4] = "Количествочасов";.Cells[4, 4] = "Теория";
workSheet.Cells[4, 5] = "Лабораторные и практические работы";.Cells[4, 6] = "Экзамены";.Cells[4, 7] = "Курсовое проектирование";.Cells[4, 8] = "Прием курсовых проектов";.Cells[4, 9] = "Практика";.Cells[4, 10] = "Дипломное проектирование";.Cells[4, 11] = "ГАК, ГЭК";.Cells[4, 12] = "Дополнительные занятия";
workSheet.Cells[4, 13] = "Всего";rowExcel = 5;(int i = 0; i < ConnectingPeople.Rows.Count; i++)
{.Cells[rowExcel, "B"] = ConnectingPeople.Rows[i].Cells["Предмет"].Value;.Cells[rowExcel, "C"] = ConnectingPeople.Rows[i].Cells["Фамилия"].Value;.Cells[rowExcel, "D"] = ConnectingPeople.Rows[i].Cells["Теория"].Value;.Cells[rowExcel, "E"] = ConnectingPeople.Rows[i].Cells["Лабораторные"].Value;.Cells[rowExcel, "F"] = ConnectingPeople.Rows[i].Cells["Экзаменационные"].Value;.Cells[rowExcel, "G"] = ConnectingPeople.Rows[i].Cells["ККП"].Value;.Cells[rowExcel, "H"] = ConnectingPeople.Rows[i].Cells["ПКП"].Value;.Cells[rowExcel, "I"] = ConnectingPeople.Rows[i].Cells["РПз"].Value;.Cells[rowExcel, "J"] = ConnectingPeople.Rows[i].Cells["ДП"].Value;.Cells[rowExcel, "K"] = ConnectingPeople.Rows[i].Cells["ГАК"].Value;.Cells[rowExcel, "L"] = ConnectingPeople.Rows[i].Cells["ДЗ"].Value;.Cells[rowExcel, "M"] = ConnectingPeople.Rows[i].Cells["Первое"].Value;.Cells[rowExcel, "N"] = ConnectingPeople.Rows[i].Cells["Второе"].Value;
++rowExcel;
}pathToXmlFile;= Environment.CurrentDirectory + "\\" + "Н-Техникум.xls";.SaveAs(pathToXmlFile);.Quit();
}ExportToExcel1()
{.Application exApp = new Excel.Application();.Visible = true;.Workbooks.Add();._Worksheet workSheet = (Excel.Worksheet)exApp.ActiveSheet;
workSheet.Cells[1, 1] = "Распределение нагрузки на";
workSheet.Cells[1, 2] = "2014-2015";.Cells[1, 3] = "учебныйгод";.Cells[2, 1] = "Преподаватель";.Cells[3, 1] = "Предмет";.Cells[3, 2] = "Группа";.Cells[3, 3] = "Количествочасов";
workSheet.Cells[4, 3] = "Теория";.Cells[4, 4] = "Лабораторные и практические работы";.Cells[4, 5] = "Экзамены";.Cells[4, 6] = "Курсовое проектирование";.Cells[4, 7] = "Прием курсовых проектов";.Cells[4, 8] = "Практика";.Cells[4, 9] = "Дипломное проектирование";.Cells[4, 10] = "ГАК, ГЭК";.Cells[4, 11] = "Дополнительные занятия";
workSheet.Cells[4, 12] = "Всего";
rowExcel = 5; Otchot.(int i = 0; i < Otchot.Rows.Count; i++)
{.Cells[rowExcel, "A"] = Otchot.Rows[i].Cells["Предмет"].Value;.Cells[rowExcel, "B"] = Otchot.Rows[i].Cells["Группа"].Value;.Cells[rowExcel, "C"] = Otchot.Rows[i].Cells["Теория"].Value;.Cells[rowExcel, "D"] = Otchot.Rows[i].Cells["Лабораторные"].Value;.Cells[rowExcel, "E"] = Otchot.Rows[i].Cells["Экзамен"].Value;.Cells[rowExcel, "F"] = Otchot.Rows[i].Cells["ККП"].Value;.Cells[rowExcel, "G"] = Otchot.Rows[i].Cells["ПКП"].Value;.Cells[rowExcel, "H"] = Otchot.Rows[i].Cells["РПр"].Value;.Cells[rowExcel, "I"] = Otchot.Rows[i].Cells["ДП"].Value;.Cells[rowExcel, "J"] = Otchot.Rows[i].Cells["ГАК"].Value;.Cells[rowExcel, "K"] = Otchot.Rows[i].Cells["ДЗ"].Value;.Cells[rowExcel, "L"] = Otchot.Rows[i].Cells["Первое"].Value;.Cells[rowExcel, "M"] = Otchot.Rows[i].Cells["Второе"].Value;
++rowExcel;
}pathToXmlFile;= Environment.CurrentDirectory + "\\" + "Н-Преподаватьели.xls";.SaveAs(pathToXmlFile);.Quit();
}
}
Приложение
17
ЧастькодапрограммыRaspis
Raspis(string constrc, Form1 DIL)
{();.constrc = constrc;= DIL;.Add(button1);Butts.Add(button2); Butts.Add(button3); Butts.Add(button4); Butts.Add(button5); Butts.Add(button6); Butts.Add(button7); Butts.Add(button8); Butts.Add(button9); Butts.Add(button10); Butts.Add(button11); Butts.Add(button12); Butts.Add(button13); Butts.Add(button14); Butts.Add(button15); Butts.Add(button16); Butts.Add(button17); Butts.Add(button18); Butts.Add(button19); Butts.Add(button20); Butts.Add(button21); Butts.Add(button22); Butts.Add(button23); Butts.Add(button24); Butts.Add(button25); Butts.Add(button26); Butts.Add(button27); Butts.Add(button28); Butts.Add(button29); Butts.Add(button30); Butts.Add(button31); Butts.Add(button32); Butts.Add(button33); Butts.Add(button34); Butts.Add(button35); Butts.Add(button36); Butts.Add(button37); Butts.Add(button38); Butts.Add(button39); Butts.Add(button40); Butts.Add(button41); Butts.Add(button42);= newSqlConnection(constrc);.Open();_corpus.Items.Add(1);_corpus.Items.Add(2);= newSqlCommand("SELECT [Surname] FROM [Teacher]", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_teacher.Items.Add((string)r[0]);
}
}.Close();_teacher.SelectedIndex = 0;_corpus.SelectedIndex = 0;
}
comboBox_corpus_SelectedIndexChanged(object sender, EventArgs e)
{.Open();_cabinet.Items.Clear();= newSqlCommand("SELECT [Number] FROM [Cabinet] WHERE [Number_campus]=" + comboBox_corpus.SelectedItem.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_cabinet.Items.Add((int)r[0]);
}
}.Close();
}
listBox_teacher_SelectedIndexChanged(object sender, EventArgs e)
{= listBox_teacher.SelectedItem.ToString();.Open();<TCab> ConL = newList<TCab>();(int i = 0; i < ConL.Count; i++)
{= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE'" + teach.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{[i].IDT = (int)r[0];
}
}
}.Close();
}
Teacher_Cabinet_button_Click(object sender, EventArgs e)
{.Visible = false;_Cabinet f1 = newTeacher_Cabinet(constrc, this);.Show();
}IDteacher;IDcab;<TS> Cons = newList<TS>();Add_Teacher_Cabinet_button_Click(object sender, EventArgs e)
{_subject.Items.Clear();.Open();= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE '" + listBox_teacher.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{= (int)r[0];
}
}= newSqlCommand("SELECT [ID_cabinet] FROM [Cabinet] WHERE [Number]=" + listBox_cabinet.SelectedItem.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [ID_teacher], [ID_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher]=" + IDteacher.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newTS((int)r[0], (int)r[1]));
}
}(int i = 0; i < Cons.Count; i++)
{= newSqlCommand("SELECT [Name_subject] FROM [Subject] WHERE [ID_subject]=" + Cons[i].IDS.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{_subject.Items.Add((string)r[0]);
}
}
}.Close();
}IDsubj;IDTS;
Connect_button_Click(object sender, EventArgs e)
{
{.Open();= newSqlCommand("SELECT [ID_subject] FROM [Subject] WHERE [Name_subject] LIKE '" + listBox_subject.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [ID_Teacher_Subject] FROM [Teacher_Subject] WHERE [ID_Subject]=" + IDsubj.ToString() + "AND [ID_Teacher]=" + IDteacher.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("INSERT INTO [Teacher_Cabinet] ([ID_Teacher_Subject], [ID_Cabinet]) VALUES ('" + IDTS.ToString() + "','" + IDcab.ToString() + "')", con);.ExecuteNonQuery();.Show("Связьпреподаватель - кабинет - предметдобавлена!");.Close();
}
{.Show("Возниклаошибка, этасвязьужесуществовала");
}
}
Exit_button_Click(object sender, EventArgs e)
{.Exit();
}IDt1;IDt2;<ConectTeachSubject> Rt = newList<ConectTeachSubject>();<Connect> Conn = newList<Connect>();listBox_Select_SelectedIndexChanged(object sender, EventArgs e)
{_Info.Rows.Clear();.Open();
(rb_Teacher.Checked == true)
{= newSqlCommand("SELECT [ID_Teacher] FROM [Teacher] WHERE [Surname] LIKE'" + listBox_Select.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{= (int)r[0];
}
}= newSqlCommand("SELECT [ID_Teacher_Subject], [ID_Teacher], [ID_Subject] FROM [Teacher_Subject] WHERE [ID_Teacher]=" + IDt1.ToString(), con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{.Add(newConectTeachSubject((int)r[0], (int)r[1], (int)r[2]));//былпиздец
}
}(int i = 0; i < Rt.Count; i++)
{= newSqlCommand(@"SELECT [Number], [Itog], [Surname],[Name_subject], [Grup_Name][Teacher] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [Name_subject], [Grup_Name][Subject] INNER JOIN (SELECT [Number], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name][Cabinet] INNER Join(SELECT [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject], [Grup_Name](SELECT [ID_Grup], [ID_Cabinet], [Itog], [ID_Teacher], [ID_Subject][Connect] INNER JOIN [Teacher_Subject] on.ID_Teacher_Subject=Teacher_Subject.ID_Teacher_SubjectTeacher_Subject.ID_Teacher_Subject =" + Rt[i].ID_teacher_subject + @") AS t1 INNER JOIN [Grup]t1.ID_Grup=Grup.ID_Grup) AS t2 ON t2.ID_Cabinet=Cabinet.ID_cabinet) as t3Subject.ID_subject=t3.ID_Subject) AS t4 ON Teacher.ID_Teacher=t4.ID_Teacher", con);(SqlDataReader r = com.ExecuteReader())
{(r.Read())
{a = r[0]; var b = r[1] isint ? r[1] : 0; var c = r[2]; var d = r[3]; var e1 = r[4];.Add(newConnect((string)c, (string)d, (string)e1, (int)a, (int)b));
}
}
}_Info.Rows.Clear();(int i = 0; i < Conn.Count; i++)
{_Info.Rows.Add();_Info.Rows[i].Cells[0].Value = Conn[i].grup;_Info.Rows[i].Cells[1].Value = Conn[i].subject;_Info.Rows[i].Cells[2].Value = Conn[i].Itog.ToString();_Info.Rows[i].Cells[3].Value = Conn[i].cabinet.ToString();
}awidth3 = dataGridView_Info.Width / dataGridView_Info.ColumnCount;(int i = 0; i < dataGridView_Info.ColumnCount; i++)_Info.Columns[i].Width = awidth3;
}
{(rb_Group.Checked == true)
{= newSqlCommand("SELECT [ID_Grup] FROM [Grup] WHERE [Grup_Name] LIKE'" + listBox_Select.SelectedItem.ToString() + "'", con);(SqlDataReader r = com.ExecuteReader())