public void bindKategoriler() { BlogSitesiEntities2 db = new BlogSitesiEntities2(); var Kategori = db.Kategori.ToList(); BindDropDownList(DrpKategoriler, Kategori, "KategoriAdi"); }
protected void Button1_Click(object sender, EventArgs e) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); int id = int.Parse(Request.QueryString["Id"]); var guncelkayit = db.Kategori.Find(id); guncelkayit.KategoriAdi = txtKategoriAdi.Text; guncelkayit.KategoriAciklama = txtArea.Text; db.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); if (!Page.IsPostBack) { int id = int.Parse(Request.QueryString["Id"]); var veri = db.Kategori.Find(id); txtKategoriAdi.Text = veri.KategoriAdi; txtArea.Text = veri.KategoriAciklama; } }
protected void Button1_Click(object sender, EventArgs e) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); Makale makaleAdd = new Makale(); makaleAdd.KategoriId = Convert.ToInt32(DrpKategoriler.SelectedValue); makaleAdd.MakaleBaslik = txtmakaleAdi.Text; makaleAdd.MakaleIcerik = txtArea.Text; makaleAdd.MakaleEtiketlemeTarihi = DateTime.Parse(txtEtiketTarihi.Text); db.Makale.Add(makaleAdd); db.SaveChanges(); Response.Redirect("makaleler.aspx"); }
protected void DrpKategoriler_SelectedIndexChanged(object sender, EventArgs e) { try { BlogSitesiEntities2 db = new BlogSitesiEntities2(); int kategoriId = Convert.ToInt32(DrpKategoriler.SelectedValue); var kategories = db.Kategori.Where(x => x.KategoriId == kategoriId).ToList(); BindDropDownList(DrpKategoriler, kategories, "KategoriAdi"); } catch (Exception) { throw; } }
protected void Button1_Click(object sender, EventArgs e) { try { BlogSitesiEntities2 db = new BlogSitesiEntities2(); Kategori kategori = new Kategori(); kategori.KategoriAdi = txtKategoriAdi.Text; kategori.KategoriAciklama = txtArea.Text; db.Kategori.Add(kategori); db.SaveChanges(); Response.Redirect("kategoriler.aspx"); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); if (!Page.IsPostBack) { int id = int.Parse(Request.QueryString["Id"]); var veri = from m in db.Makale join k in db.Kategori on m.KategoriId equals k.KategoriId select new { k.KategoriAdi }; DrpKategoriler.SelectedValue = veri.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { try { BlogSitesiEntities2 db = new BlogSitesiEntities2(); var makaleler = db.Makale.ToList(); Repeater1.DataSource = makaleler; Repeater1.DataBind(); } catch (Exception) { throw; } if (Request.QueryString["Id"] != null) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); int id = int.Parse(Request.QueryString["Id"]); var makaleSil = db.Makale.Find(id); db.Makale.Remove(makaleSil); db.SaveChanges(); Response.Redirect("makaleler.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { BlogSitesiEntities2 db = new BlogSitesiEntities2(); try { var kategoriler = db.Kategori.ToList(); Repeater1.DataSource = kategoriler; Repeater1.DataBind(); } catch (Exception) { throw; } if (Request.QueryString["Id"] != null) { int id = int.Parse(Request.QueryString["Id"]); var silKayit = db.Kategori.Find(id); db.Kategori.Remove(silKayit); db.SaveChanges(); Response.Redirect("kategoriler.aspx"); } }