/// <summary> /// Kullanıcı giriş yaptığında çalışır, ana sayfadaki haber kategorilerinin her biri için çağrılması gerekir. /// </summary> /// <param name="cat">string olarak gönderilen kategori ismi örneğin: "World"</param> protected void NewsBoxSetUsr(string cat, string Langs) { var connection = WebConfigurationManager.ConnectionStrings["DBConnection"]; SqlConnection sc = new SqlConnection(connection.ConnectionString); SqlCommand c = new SqlCommand("EXECUTE spViewNewsCatLangBeginAmount '" + cat + "', '" + Langs + "',1,6"); SqlDataReader r; c.Connection = sc; try { sc.Open(); r = c.ExecuteReader(); if (cat == "World") { RepeaterWorld.DataSource = r; RepeaterWorld.DataBind(); } else if (cat == "Business") { RepeaterBusiness.DataSource = r; RepeaterBusiness.DataBind(); } else if (cat == "Technology") { RepeaterTech.DataSource = r; RepeaterTech.DataBind(); } else if (cat == "Science") { RepeaterScience.DataSource = r; RepeaterScience.DataBind(); } else if (cat == "Health") { RepeaterHealth.DataSource = r; RepeaterHealth.DataBind(); } else if (cat == "Video") { RepeaterVideo.DataSource = r; RepeaterVideo.DataBind(); } else if (cat == "Sport") { RepeaterSport.DataSource = r; RepeaterSport.DataBind(); } r.Close(); } catch (SqlException ex) { Response.Write("Error!" + ex.Message); } finally { sc.Close(); sc.Dispose(); } }
private void HealthBinding() { HealthCount = _query.HealthNewsCount(); if (FavorableCount > 0) { var health = _query.HealthNews(5, 1); RepeaterHealth.DataSource = from it in health select new { it.Title }; RepeaterHealth.DataBind(); } }