protected void SetLatestNews() { DataTable newlist = FrontNews.GetFrontNewsList(5); LiteralControl literalControl; foreach (DataRow child in newlist.Rows) { DateTime modified = DateTime.Parse(child["Modified"].ToString()); string newsid = child["NewsID"].ToString(); string newstitle = child["NewsTitle"].ToString(); //<li><span>2009.09.18</span><a href="#">Lorem Ipsum Dolor sit amet sjtpua cons...</a></li> literalControl = new LiteralControl(String.Format("<li><span>{0}</span><a href='{1}'>{2}</a></li>\n", modified.ToString("yyyy'.'MM'.'dd"), "/News/NewsList.aspx?NewsID=" + newsid, newstitle)); ContentsPlaceHolder.Controls.Add(literalControl); } }
protected void BindData() { int howManyPages = 1; DataTable news = SiteFrontend.FrontNews.GetNewsIDs(int.Parse(_page), _newsPerPage, out howManyPages); NewsRepeater.DataSource = news; NewsRepeater.DataBind(); if (_newsID == 0) { if (news.Rows.Count > 0) { DataRow row = news.Rows[0]; _newsID = int.Parse(row["NewsID"].ToString()); } } if (_newsID > 0) { DataTable n = FrontNews.GetNews(_newsID); if (n.Rows.Count > 0) { DataRow r = n.Rows[0]; lblNewsTitle.Text = r["NewsTitle"].ToString(); lblNewsDate.Text = String.Format("{0:M/d/yyyy}", DateTime.Parse(r["Modified"].ToString())); NewsContentDiv.InnerHtml = r["NewsDesc"].ToString(); } } if (howManyPages > 1) { int currentPage = Int32.Parse(_page); pagingLabel.Visible = true; previousLink.Visible = true; nextLink.Visible = true; firstLink.Visible = true; lastLink.Visible = true; pagingLabel.Text = _page + " / " + howManyPages.ToString(); // create previous link if (currentPage == 1) { previousLink.Enabled = false; firstLink.Enabled = false; } else { NameValueCollection query = Request.QueryString; string paramName, newQueryString = "?"; for (int i = 0; i < query.Count; i++) { if (query.AllKeys[i] != null) { if ((paramName = query.AllKeys[i].ToString()).ToUpper() != "PAGE") { newQueryString += paramName + "=" + query[i] + "&"; } } } previousLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + (currentPage - 1).ToString(); firstLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=1"; } //create next link if (currentPage == howManyPages) { nextLink.Enabled = false; lastLink.Enabled = false; } else { NameValueCollection query = Request.QueryString; string paramName, newQueryString = "?"; for (int i = 0; i < query.Count; i++) { if (query.AllKeys[i] != null) { if ((paramName = query.AllKeys[i].ToString()).ToUpper() != "PAGE") { newQueryString += paramName + "=" + query[i] + "&"; } } } nextLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + (currentPage + 1).ToString(); lastLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + howManyPages.ToString(); } } }