コード例 #1
0
        public void dersSil(VAR.ders Sders)
        {
            SqlCommand cmd = new SqlCommand("derssil", con);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@dersno", Sders.Dersno);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try {
                VAR.ders yders = new Varlıklar.ders(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text);
                yders.Dersno = yeniders.DGuncelle(yders);
                ((Form3)this.Owner).derslistele();

                this.Visible = false;
            }
            catch { MessageBox.Show("Hatalı işlem."); }
        }
コード例 #3
0
        public int DGuncelle(VAR.ders ders)
        {
            SqlCommand cmd = new SqlCommand("dersduzenle", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@dersadi", ders.Dersadi);
            cmd.Parameters.AddWithValue("@bolum", ders.Bolum);
            cmd.Parameters.AddWithValue("@hocasi", ders.Hocasi);
            cmd.Parameters.AddWithValue("@donem", ders.Donem);

            con.Open();
            int id = Convert.ToInt32(cmd.ExecuteScalar());

            con.Close();
            return(id);
        }
コード例 #4
0
 private void button3_Click(object sender, EventArgs e)
 {
     VAR.ders dersSil = new VAR.ders(Convert.ToInt32(dataGridView3.SelectedRows[0].Cells[0].Value));
     yeniders.dersSil(dersSil);
     derslistele();
 }