Beispiel #1
0
        private void button_extension_Click(object sender, EventArgs e)
        {
            try
            {
                foreach (DataGridViewRow item in dataGridView1.SelectedRows)
                {
                    name       = item.Cells[1].Value.ToString();
                    id         = Convert.ToInt32(item.Cells[0].Value.ToString());
                    tuition    = Convert.ToInt32(item.Cells[2].Value.ToString());
                    teacher_id = Convert.ToInt32(item.Cells[3].Value.ToString());
                }

                Subject_Add subject_add = new Subject_Add();
                subject_add.Passvalue_id      = id;
                subject_add.Passvalue_name    = name;
                subject_add.Passvalue_num     = 1;
                subject_add.Passvalue_techer  = teacher_id;
                subject_add.Passvalue_tuition = tuition;
                subject_add.ShowDialog();
            }
            catch (Exception exception)
            {
                MessageBox.Show("과목을 선택해주세요", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            string           query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호  FROM SUBJECT ORDER BY ID ASC";
            OracleDataReader rdr   = DBManager.GetInstance().ExecuteReader(query);

            dataGridView1.DataSource = null;

            DataTable dt = new DataTable();

            dt.Load(rdr);
            dataGridView1.DataSource = dt;
        }
Beispiel #2
0
        private void button_Add_Click(object sender, EventArgs e)
        {
            Subject_Add subject_add = new Subject_Add();

            subject_add.ShowDialog();

            string           query = "SELECT id as 과목번호, name as 과목명, tuition as 수강료, teacher_id as 강사번호  FROM SUBJECT ORDER BY ID ASC";
            OracleDataReader rdr   = DBManager.GetInstance().ExecuteReader(query);

            dataGridView1.DataSource = null;

            DataTable dt = new DataTable();

            dt.Load(rdr);
            dataGridView1.DataSource = dt;
        }