protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { int id = Convert.ToInt32(Request.QueryString["Kategoriid"]); islem = Request.QueryString["islem"]; } SqlCommand cmd = new SqlCommand(" Select * From Tbl_Kategoriler ", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); Panel2.Visible = false; Panel4.Visible = false; if (islem == "sil") { int id = Convert.ToInt32(Request.QueryString["Kategoriid"]); SqlCommand cmdDelete = new SqlCommand("Delete From Tbl_Kategoriler where kategoriid=@p1", bgl.Connection()); cmdDelete.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); cmdDelete.ExecuteNonQuery(); bgl.Connection().Close(); } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Tarifid"]); if (Page.IsPostBack == false) { SqlCommand cmd = new SqlCommand("Select * From Tbl_Tarifler where Tarifid=@p1", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TextBox1.Text = dr[1].ToString(); TextBox2.Text = dr[2].ToString(); TextBox3.Text = dr[3].ToString(); TextBox4.Text = dr[5].ToString(); TextBox5.Text = dr[6].ToString(); } bgl.Connection().Close(); } if (Page.IsPostBack == false) { SqlCommand cmd1 = new SqlCommand("Select * From Tbl_Kategoriler", bgl.Connection()); SqlDataReader dr1 = cmd1.ExecuteReader(); DropDownList1.DataTextField = "KategoriAd"; DropDownList1.DataValueField = "Kategoriid"; DropDownList1.DataSource = dr1; DropDownList1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { Panel2.Visible = false; if (Page.IsPostBack == false) { SqlCommand cmd = new SqlCommand("Select *From Tbl_Hakkımızda ", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TextBox1.Text = dr[0].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("Select *From Tbl_Hakkımızda", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList2.DataSource = dr; DataList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Kategoriid"]); if (Page.IsPostBack == false) { SqlCommand cmd = new SqlCommand(" Select * From Tbl_Kategoriler where Kategoriid=@p1", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TextBox1.Text = dr[1].ToString(); TextBox2.Text = dr[2].ToString(); } bgl.Connection().Close(); } }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(" Select * From Tbl_Kategoriler", bgl.Connection()); SqlDataReader oku = cmd.ExecuteReader(); DataList1.DataSource = oku; DataList1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Panel2.Visible = false; SqlCommand cmd = new SqlCommand("Select * From Tbl_Mesajlar", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Yorumid"]); if (Page.IsPostBack == false) { SqlCommand cmd = new SqlCommand(" Select YorumAdSoyad,YorumMail,Yorum,YemekAd From Tbl_Yorum inner join Tbl_Yemeklerr on Tbl_Yorum.Yemekid=Tbl_Yemeklerr.Yemekid where Yorumid=@p1", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { txt_adsoyad.Text = dr[0].ToString(); txt_mail.Text = dr[1].ToString(); txt_içerik.Text = dr[2].ToString(); txt_yemek.Text = dr[3].ToString(); } bgl.Connection().Close(); } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Mesajid"]); if (Page.IsPostBack == false) { SqlCommand cmd = new SqlCommand("Select MesajGönderen,MesajjBaşlık,MesajMail,Mesajİçerik From Tbl_Mesajlar where Mesajid=@p1 ", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { txt_adsoyad.Text = dr[0].ToString(); txt_baslik.Text = dr[1].ToString(); txt_mail.Text = dr[2].ToString(); txt_icerik.Text = dr[3].ToString(); } bgl.Connection().Close(); } }
protected void Button1_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("insert into Tbl_Mesajlar (MesajGönderen,MesajjBaşlık,MesajMail,Mesajİçerik)values(@p1,@p2,@p3,@p4)", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", txt_as.Text); cmd.Parameters.AddWithValue("@p2", txt_konu.Text); cmd.Parameters.AddWithValue("@p3", txt_mailad.Text); cmd.Parameters.AddWithValue("@p4", txt_mesaj.Text); cmd.ExecuteNonQuery(); bgl.Connection().Close(); }
protected void Page_Load(object sender, EventArgs e) { int yemekid = Convert.ToInt32(Request.QueryString["yemekid"]); SqlCommand cmd = new SqlCommand("Select YemekAd From Tbl_Yemeklerr Where yemekid=@p1", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", (yemekid > 0 ? yemekid : 0)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Label7.Text = dr[0].ToString(); } bgl.Connection().Close(); SqlCommand cmd2 = new SqlCommand(" Select * From Tbl_Yorum where yemekid=@p2", bgl.Connection()); cmd2.Parameters.AddWithValue("@p2", yemekid); SqlDataReader dr2 = cmd2.ExecuteReader(); DataList2.DataSource = dr2; DataList2.DataBind(); }
protected void Btn_TarifOner_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(" insert into Tbl_Tarifler(TarifAd,TarifMalzeme,TarifYapılış,TarifResim,TarifSahip,TarifSahipMail) values (@t1,@t2,@t3,@t4,@t5,@t6)", bgl.Connection()); cmd.Parameters.AddWithValue("@t1", TxtTarifAd.Text); cmd.Parameters.AddWithValue("@t2", TxtMalzemeler.Text); cmd.Parameters.AddWithValue("@t3", TxtYapılıs.Text); cmd.Parameters.AddWithValue("@t4", FileUpload1.FileName); cmd.Parameters.AddWithValue("@t5", TxtTarifOneren.Text); cmd.Parameters.AddWithValue("@t6", TxtMail.Text); cmd.ExecuteNonQuery(); bgl.Connection().Close(); Response.Write("Tarifiniz alınmıştır"); }
protected void Page_Load(object sender, EventArgs e) { Panel2.Visible = false; Panel4.Visible = false; if (Page.IsPostBack == false) { int id = Convert.ToInt32(Request.QueryString["Yemekid"]); islem = Request.QueryString["islem"]; SqlCommand cmd1 = new SqlCommand("Select * From Tbl_Kategoriler", bgl.Connection()); SqlDataReader dr1 = cmd1.ExecuteReader(); DropDownList1.DataTextField = "KategoriAd"; DropDownList1.DataValueField = "Kategoriid"; DropDownList1.DataSource = dr1; DropDownList1.DataBind(); } SqlCommand cmd = new SqlCommand(" Select * From Tbl_Yemeklerr", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); if (islem == "sil") { int id = Convert.ToInt32(Request.QueryString["Yemekid"]); SqlCommand cmd2 = new SqlCommand("select * from Tbl_Yemeklerr where yemekid=@p1", bgl.Connection()); cmd2.Parameters.AddWithValue("@p1", id); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { Kategorriid = dr2[7].ToString(); } SqlCommand cmdDelete = new SqlCommand("Delete From Tbl_Yemeklerr where Yemekid=@p1", bgl.Connection()); cmdDelete.Parameters.AddWithValue("@p1", (id > 0 ? id : 0)); cmdDelete.ExecuteNonQuery(); bgl.Connection().Close(); SqlCommand cmddelete1 = new SqlCommand("Update Tbl_Kategoriler set KategoriAdet=KategoriAdet-1 where kategoriid=@p1", bgl.Connection()); cmddelete1.Parameters.AddWithValue("@p1", Kategorriid); cmddelete1.ExecuteNonQuery(); bgl.Connection().Close(); } }
protected void Page_Load(object sender, EventArgs e) { Panel2.Visible = false; Panel4.Visible = false; SqlCommand cmd = new SqlCommand(" select * from Tbl_Yorum where YorumOnay=1", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); SqlCommand cmd2 = new SqlCommand("select * from Tbl_Yorum where YorumOnay =0", bgl.Connection()); SqlDataReader dr2 = cmd2.ExecuteReader(); DataList2.DataSource = dr2; DataList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("Select * From Tbl_Yemeklerr where Durum=1", bgl.Connection()); SqlDataReader oku = cmd.ExecuteReader(); DataList2.DataSource = oku; DataList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { kategoriid = Request.QueryString["Kategoriid"]; SqlCommand cmd = new SqlCommand(" Select * From Tbl_Yemeklerr where Kategoriid=@p1", bgl.Connection()); cmd.Parameters.AddWithValue("@p1", kategoriid); SqlDataReader dr = cmd.ExecuteReader(); DataList2.DataSource = dr; DataList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Panel2.Visible = false; Panel4.Visible = false; SqlCommand cmd = new SqlCommand("Select * From Tbl_Tarifler where TarifDurum=0", bgl.Connection()); SqlDataReader dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); SqlCommand cmd1 = new SqlCommand("Select * From Tbl_Tarifler where TarifDurum=1", bgl.Connection()); SqlDataReader dr1 = cmd.ExecuteReader(); DataList2.DataSource = dr1; DataList2.DataBind(); }