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");
}
