protected void Page_Load(object sender, EventArgs e) { dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(5); if (dtNewsCategory.Rows.Count > 0) { int page = 10; dtNews = taNews.SelectNewsbyNewsCategoryId(5); if (dtNews.Rows.Count > 0) { PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = dtNews.DefaultView; objPds.AllowPaging = true; objPds.PageSize = page; objPds.CurrentPageIndex = CurrentPage; Repeater1.DataSource = objPds; Repeater1.DataBind(); } else { Repeater1.Visible = false; } } else { Repeater1.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.QueryString["NewsId"] != null) { int NewsId = Convert.ToInt32(Request.QueryString["NewsId"]); dtNews = taNews.SelectNewsbyNewsId(NewsId); if (dtNews.Rows.Count > 0) { lblNewsTitle.Text = dtNews[0].Title.ToString(); imgNews.ImageUrl = "thumbnail.aspx?Image=Images/NewsImages/" + dtNews[0].MainImage.ToString() + "&size=500"; lblNewsDescription.Text = dtNews[0].LongDescription.ToString(); } else { imgNews.Visible = false; lblNewsDescription.Visible = false; } } else { imgNews.Visible = false; lblNewsDescription.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; SelectCategories(); if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["NewsId"] != null) { int newsId = Convert.ToInt32(Request.QueryString["NewsId"].ToString()); dtNews = taNews.SelectNewsbyNewsId(newsId); if (dtNews.Rows.Count > 0) { ddlType.Items.FindByValue(dtNews[0].NewsCategoryId.ToString()).Selected = true; txtTitle.Text = dtNews[0].Title.ToString(); txtStartDate.Text = dtNews[0].StartDate.ToString(); txtShortDescription.Text = dtNews[0].ShortDescription.ToString(); txtLongDescription.Text = dtNews[0].LongDescription.ToString(); lblImage.Text = dtNews[0].MainImage.ToString(); Image1.ImageUrl = "~/thumbnail.aspx?Image=Images/NewsImages/" + dtNews[0].MainImage.ToString() +"&size=100"; } } else { btnEdit.Visible = false; lblMsg.Text = "No Record Found"; } }
private void BindData() { dtNews = taNews.SelectAllNews(); if (dtNews.Rows.Count > 0) { GridView1.DataSource = dtNews; GridView1.DataBind(); } else { GridView1.Visible = false; lblMsg.Text = "No record found"; } }
private void ItemsGet() { if (Request.QueryString["NewsCategoryId"] != null) { int NewsCategoryId = Convert.ToInt32(Request.QueryString["NewsCategoryId"]); dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(NewsCategoryId); if (dtNewsCategory.Rows.Count > 0) { int page = 10; lblCategoryName.Text = dtNewsCategory[0].NewsCategoryTitle.ToString(); dtNews = taNews.SelectNewsbyNewsCategoryId(NewsCategoryId); if (dtNews.Rows.Count > 0) { PagedDataSource objPds = new PagedDataSource(); objPds.DataSource = dtNews.DefaultView; objPds.AllowPaging = true; objPds.PageSize = page; objPds.CurrentPageIndex = CurrentPage; //objPds.CurrentPageIndex = CurrentPage - 1; int count = objPds.PageCount; lblCurrentPage.Text = "Page " + (CurrentPage + 1).ToString() + " of " + objPds.PageCount.ToString(); //Disable Prev or Next buttons if necessary //Button1.Visible = !objPds.IsFirstPage; //Button2.Visible = !objPds.IsLastPage; if (objPds.IsFirstPage) Button1.Visible = false; else Button1.Visible = true; if (objPds.IsLastPage) Button2.Visible = false; else Button2.Visible = true; Repeater1.DataSource = objPds; Repeater1.DataBind(); } else { Repeater1.Visible = false; Button1.Visible = false; Button2.Visible = false; } } else { Repeater1.Visible = false; Button1.Visible = false; Button2.Visible = false; } } else { Repeater1.Visible = false; Button1.Visible = false; Button2.Visible = false; } }