private void Form1_Load(object sender, EventArgs e)
        {
            this.statE_EXAMTableAdapter1.Fill(this.commonDS1.STATE_EXAM);
            this.yearlY_PROJECTTableAdapter1.Fill(this.commonDS1.YEARLY_PROJECT);
            this.pRACTICSTableAdapter.Fill(this.commonDS1.PRACTICS);
            this.cOMMON_STUDENT_PLANTableAdapter.Fill(this.commonDS1.COMMON_STUDENT_PLAN);            
            this.tRANSFERSTableAdapter.Fill(this.commonDS1.TRANSFERS);
            this.sTUDENTTableAdapter.Fill(this.commonDS1.STUDENT);
            this.sTUDY_PROFILETableAdapter.Fill(this.commonDS1.STUDY_PROFILE);        
            

            dvTransfers = new DataView(commonDS1.Tables["TRANSFERS"]);
            dvTransfers.RowFilter = "STUDENT_ID='" + sTUDENT_IDTextBox.Text+"'";
            dvTransfers.ListChanged += new ListChangedEventHandler(dvsStudentIdInsert_ListChanged);
            transfersGrid.DataSource = dvTransfers;
            transfersGrid.Columns[4].Visible = false;
            transfersGrid.Columns[0].HeaderText = "Номер приказа";
            transfersGrid.Columns[1].HeaderText = "Дата приказа";
            transfersGrid.Columns[2].HeaderText = "Курс";
            transfersGrid.Columns[3].HeaderText = "Содержание приказа";
            transfersGrid.Columns[3].Width = 170;
            dvCommon_SP = new DataView(commonDS1.Tables["COMMON_STUDENT_PLAN"]);
            dvCommon_SP.RowFilter = "STUDENT_ID='" + sTUDENT_IDTextBox.Text + 
                                    "' AND SEMESTER='"+(semestrBox.SelectedIndex+1)+"'";
            dvCommon_SP.ListChanged+=new ListChangedEventHandler(dvCommon_SP_ListChanged);
            dataGridView1.DataSource = dvCommon_SP;
            dataGridView1.Columns[0].Visible = false;
            dataGridView1.Columns[1].Visible = false;
            dataGridView1.Columns[2].Visible = false;
            SetColumnsWidth(dataGridView1, 0, 0, 0, 210, 70, 50, 50, 100);

            additional = new DataView(commonDS1.Tables["PRACTICS"]);
            additional.RowFilter = "STUDENT_ID='" + sTUDENT_IDTextBox.Text + "'";
            additional.ListChanged += new ListChangedEventHandler(dvsStudentIdInsert_ListChanged);
            dataGridView2.DataSource = additional;
            dataGridView2.Columns[1].Visible = false;
            SetColumnsWidth(dataGridView2, 29, 0, 158, 157, 52, 90);

            currentStudentRow = ((DataRowView)sTUDENTBindingSource.Current).Row;
            DiplomaThemeValidate();
        }

        private void SetColumnsWidth(DataGridView dgv, params int[] columns)
        {
            for (int i = 0; i < columns.Length; i++)
                dgv.Columns[i].Width = columns[i];
        }

        private void DiplomaThemeValidate()
        {
            if (dIPLOMA_THEMETextBox.Text.Length > 0)
            {
                dIPLOMA_MARKComboBox.Enabled = true;
                qUALIFICATION_PROTTextBox.Enabled = true;
                qUALIFICATION_DATEMaskedTextBox.Enabled = true;
            }
            else
            {
                dIPLOMA_MARKComboBox.Enabled = false;
                qUALIFICATION_PROTTextBox.Enabled = false;
                qUALIFICATION_DATEMaskedTextBox.Enabled = false;
            }
        }

        private void bindingNavigatorMoveItem_Click(object sender, EventArgs e)
        {
            currentStudentRow = ((DataRowView)sTUDENTBindingSource.Current).Row;
            rowFak_spec = currentStudentRow.GetParentRow(commonDS1.Relations["FK_STUDENT_1"]);
            fACULTYTextBox.Text = rowFak_spec["FACULTY"].ToString();
            sPECIALITYTextBox.Text = rowFak_spec["SPECIALITY"].ToString();
            qUALIFICATIONTextBox.Text = rowFak_spec["QUALIFICATION"].ToString();
            dvTransfers.RowFilter = "STUDENT_ID='" + sTUDENT_IDTextBox.Text + "'";
            DiplomaThemeValidate();
        }

        private void dvsStudentIdInsert_ListChanged(object sender, ListChangedEventArgs e)
        {
            if (e.ListChangedType == ListChangedType.ItemAdded)
            {
                ((DataView)sender)[e.NewIndex].Row["STUDENT_ID"] = int.Parse(sTUDENT_IDTextBox.Text);
                MessageBox.Show(((DataView)sender)[e.NewIndex].Row.RowState.ToString());
            }
        }

        private void dvCommon_SP_ListChanged(object sender, ListChangedEventArgs e)
        {
            if (e.ListChangedType == ListChangedType.ItemAdded)
            {
                DataRow newRow = dvCommon_SP[e.NewIndex].Row;
                newRow["STUDENT_ID"] = int.Parse(sTUDENT_IDTextBox.Text);
                newRow["SEMESTER"] = semestrBox.SelectedIndex + 1;
                MessageBox.Show(newRow.RowState.ToString());
            }
        }

        private void saveChangesToolStripMenuItem_Click(object sender, EventArgs e)
        {           
            
            int i=tableAdapterManager.UpdateAll(commonDS1);
            MessageBox.Show(i.ToString());
        }