Пример #1
0
        private void BtnAdd_Click(object sender, EventArgs e)
        {
            string p = "";

            NewCourse frm = new NewCourse(p);

            frm.BtnAdd.Enabled  = true;
            frm.BtnEdit.Enabled = false;

            frm.Show();
            this.Hide();
        }
Пример #2
0
        private void BtnEdit_Click(object sender, EventArgs e)
        {
            NewCourse frm = new NewCourse(p);

            //Передача данных о студенте на форму редактирования

            using (SqlConnection connecting = new SqlConnection(Program.connection))
            {
                connecting.Open();


                // Данные из таблицы Курсы

                SqlCommand course = connecting.CreateCommand();
                course.CommandText = "SELECT Course FROM [NewCourse] WHERE ID= " + p;
                course.ExecuteScalar();

                SqlCommand program = connecting.CreateCommand();
                program.CommandText = "SELECT Program FROM [NewCourse] WHERE ID= " + p;
                program.ExecuteScalar();

                SqlCommand type = connecting.CreateCommand();
                type.CommandText = "SELECT Type FROM [NewCourse] WHERE ID= " + p;
                type.ExecuteScalar();

                SqlCommand datestart = connecting.CreateCommand();
                datestart.CommandText = "SELECT DateStart FROM [NewCourse] WHERE ID= " + p;
                datestart.ExecuteScalar();

                SqlCommand dateend = connecting.CreateCommand();
                dateend.CommandText = "SELECT DateEnd FROM [NewCourse] WHERE ID= " + p;
                dateend.ExecuteScalar();

                SqlCommand kolchas = connecting.CreateCommand();
                kolchas.CommandText = "SELECT KolChas FROM [NewCourse] WHERE ID= " + p;
                kolchas.ExecuteScalar();

                SqlCommand smeta = connecting.CreateCommand();
                smeta.CommandText = "SELECT Smeta FROM [NewCourse] WHERE ID= " + p;
                smeta.ExecuteScalar();

                SqlCommand typeobuch = connecting.CreateCommand();
                typeobuch.CommandText = "SELECT TypeObuch FROM [NewCourse] WHERE ID= " + p;
                typeobuch.ExecuteScalar();

                SqlCommand typepractik = connecting.CreateCommand();
                typepractik.CommandText = "SELECT TypePractik FROM [NewCourse] WHERE ID= " + p;
                typepractik.ExecuteScalar();


                //Заполнение полей на форме редактирования данных о курсе
                frm.CbCourse.Text      = Convert.ToString(course.ExecuteScalar());
                frm.CbProgram.Text     = Convert.ToString(program.ExecuteScalar());
                frm.CbTypeProg.Text    = Convert.ToString(type.ExecuteScalar());
                frm.dateStart.Value    = Convert.ToDateTime(datestart.ExecuteScalar());
                frm.dateEnd.Value      = Convert.ToDateTime(dateend.ExecuteScalar());
                frm.TbChas.Text        = Convert.ToString(kolchas.ExecuteScalar());
                frm.TbSmeta.Text       = Convert.ToString(smeta.ExecuteScalar());
                frm.CbTypeObuch.Text   = Convert.ToString(typeobuch.ExecuteScalar());
                frm.CbTypePractik.Text = Convert.ToString(typepractik.ExecuteScalar());

                frm.BtnAdd.Enabled  = false;
                frm.BtnEdit.Enabled = true;


                frm.Show();
                this.Hide();
                connecting.Close();
            }
        }