protected void Page_Load(object sender, EventArgs e) { byte id = Convert.ToByte(Request.QueryString["DersID"].ToString()); DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); dt.DersSil(id); Response.Redirect("DersListesi.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { id = Convert.ToInt32(Request.QueryString["DersID"].ToString()); DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); txtDersID.Text = id.ToString(); txtDersAd.Text = dt.DersGetir(byte.Parse(id.ToString()))[0].DersAd; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { //Dropdown liste verileri çekme DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); DropDownList.DataSource = dt.DersListesi(); DropDownList.DataTextField = "DersAd"; DropDownList.DataValueField = "DersID"; DropDownList.DataBind(); bag.baglanti(); //ders sayısı grafiklerini çekme WebChartDers.Series["Dersler"].Points.Clear(); komut = new SqlCommand("Execute GrafikDers", bag.baglanti()); dr = komut.ExecuteReader(); while (dr.Read()) { WebChartDers.Series["Dersler"].Points.AddPoint(Convert.ToString(dr[0]), int.Parse(dr[1].ToString())); } //Cinsiyet Grafik veri çekme WebChartCinsiyet.Series["Cinsiyet"].Points.Clear(); komut = new SqlCommand("Execute GrafikCinsiyet", bag.baglanti()); dr = komut.ExecuteReader(); while (dr.Read()) { WebChartCinsiyet.Series["Cinsiyet"].Points.AddPoint(Convert.ToString(dr[0]), int.Parse(dr[1].ToString())); } //Öğretmen Branş Grafik veri çekme WebChartOgretmen.Series["Öğretmen"].Points.Clear(); komut = new SqlCommand("Execute GrafikOgretmen", bag.baglanti()); dr = komut.ExecuteReader(); while (dr.Read()) { WebChartOgretmen.Series["Öğretmen"].Points.AddPoint(Convert.ToString(dr[0]), int.Parse(dr[1].ToString())); } //Not öğrenci Grafik veri çekme WebChartNot.Series["Notlar"].Points.Clear(); komut = new SqlCommand(" Select (tblOgrenci.OgrenciAd + ' ' + tblOgrenci.OgrenciSoyad) as 'ÖĞRENCİ', Sinav1 From tblNotlar inner join tblOgrenci on tblNotlar.OgrenciID = tblOgrenci.OgrenciID Where DersID = @DersID", bag.baglanti()); komut.Parameters.AddWithValue("@DersID", 1); dr = komut.ExecuteReader(); while (dr.Read()) { WebChartNot.Series["Notlar"].Points.AddPoint(Convert.ToString(dr[0]), int.Parse(dr[1].ToString())); } bag.baglanti().Close(); } }
protected void Page_Load(object sender, EventArgs e) { DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); Repeater1.DataSource = dt.DersListesi(); Repeater1.DataBind(); }
protected void btnGuncelle_Click(object sender, EventArgs e) { DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); dt.DersGuncelle(txtDersAd.Text, byte.Parse(txtDersID.Text)); Response.Redirect("DersListesi.aspx"); }
protected void btnEkle_Click(object sender, EventArgs e) { DataSetTableAdapters.tblDerslerTableAdapter dt = new DataSetTableAdapters.tblDerslerTableAdapter(); dt.DersEkle(txtDers.Text); Response.Redirect("DersListesi.aspx"); }