protected void Page_Load(object sender, EventArgs e) { SqlCommand cmUrun = new SqlCommand("Select * from Urun", baglan.baglan()); SqlDataReader drUrun = cmUrun.ExecuteReader(); DataListUrun.DataSource = drUrun; DataListUrun.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlCommand cmUrun = new SqlCommand("Select * from Urun where Yayin=" + 1 + "", baglan.baglanti()); SqlDataReader drUrun = cmUrun.ExecuteReader(); DataListUrun.DataSource = drUrun; DataListUrun.DataBind(); if (Session["KoleksiyonerEmail"] != null) { string kEmail = Session["KoleksiyonerEmail"].ToString(); SqlCommand cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglanti()); SqlDataReader drSession = cmdSession.ExecuteReader(); DatalistProfilBilgi.DataSource = drSession; DatalistProfilBilgi.DataBind(); Panel1.Visible = false; } else { DatalistProfilBilgi.Visible = false; Panel2.Visible = false; } }