示例#1
0
        private void button2_Click(object sender, EventArgs e)
        {
            Generation_Class generation_class = new Generation_Class(connectionstring);
            SqlDataReader read_spec = generation_class.ReadTable("Specialty");

            SqlDataReader read_spiski = generation_class.ReadTable("Priority");
            List<List> list_spisok = new List<List>();
            while (read_spiski.Read())
            {
                list_spisok.Add(new List { ID_student = Convert.ToInt32(read_spiski.GetValue(1)), ID_specialty = Convert.ToInt32(read_spiski.GetValue(2)), Prio = Convert.ToInt32(read_spiski.GetValue(3)), Sum = Convert.ToInt32(read_spiski.GetValue(4)) });
            }

            List<ListSpec> listSpec = new List<ListSpec>();
            while (read_spec.Read())
            {
                listSpec.Add(new ListSpec { ID = Convert.ToInt32(read_spec.GetValue(0)), Specialty = (read_spec.GetValue(1)).ToString(), Amount = Convert.ToInt32(read_spec.GetValue(2)) });
            }

            int i = 0;
            List<ListFirstSpec> listFirstSpec = new List<ListFirstSpec>();
              foreach(var k in listSpec)
            {
              DataGridView dgv = new DataGridView();
              DataGridView dgv1 = new DataGridView();
                            dgv.Name = "DGV" + i.ToString();
                            dgv.Width = 500;
                            dgv.Height = 500;
                            dgv.Left = 0;
                            dgv.Top = 0;
                            dgv.Columns.Add("123", "Номер_студента");
                            dgv.Columns.Add("123", "Приоритет");
                            dgv.Columns.Add("123", "Сумма баллов");
                            tabControl1.TabPages[i].Controls.Add(dgv);
                            foreach (var j in list_spisok)
                            {
                                if (j.ID_specialty == k.ID)
                                {

                                    //dgv.Rows.Add(j.ID_student, j.Prio, j.Sum);
                                }

                            }
                        i++;
            }
        }
示例#2
0
文件: Priority.cs 项目: Geliya94/RViP
 public Priority(string connectionstring)
 {
     InitializeComponent();
     this.connectionstring = connectionstring;
     generation_class = new Generation_Class(this.connectionstring);
 }