Esempio n. 1
0
        private void LoadStudent(long id_group)
        {
            string        sqlQuery = "SELECT * FROM Student WHERE ID_group = @id_group";
            SQLiteCommand command  = new SQLiteCommand(sqlQuery);

            command.Parameters.AddWithValue("@id_group", id_group);
            managerDataStudent.LoadData(command);
            SQLiteCommand commandInsert = new SQLiteCommand("INSERT INTO Student(FIO, ID_group) VALUES(@FIO, @ID_group)");

            commandInsert.Parameters.Add(new SQLiteParameter("@FIO", DbType.String, "FIO"));
            commandInsert.Parameters.AddWithValue("@ID_group", id_group);
            managerDataStudent.InitialCommandInsert(commandInsert);
            dataGridViewStudent.Columns["ID"].Visible       = false;
            dataGridViewStudent.Columns["ID_group"].Visible = false;
            dataGridViewStudent.Columns["FIO"].HeaderText   = "Ф.И.О.";
            dataGridViewStudent.Columns["FIO"].Width        = 500;
        }